Access Query

[AGoodGuy]

I have a query in Access 2007 called Renewal Offer Analysis and I have a table called State Policy Fees. I am trying to create a formula that will give me the policy fee added. For example:

I have a policy in the state ALA (STATE) with a 6 month term (TERM) with a Renewal (Description) and a $6.00 (policy fee) How would I write the formula in a query to add a added policy fee to the policy fee?

Note: the name is parenthesis are field names

 

[dhookom]

AGoodGuy,
Please keep your messages in the same thread and consider posting Access query questions in forum701.

Duane
Hook'D on Access
MS Access MVP