calculation within query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am using access 2002. i have a query(query 2) that is pulling a calculated
value (CurrentBal)from a previous query(query 1). in query 2, i then perform
an IIf calculation (atty fee)based on (CurrentBal), but it just prompts me to
enter the value for (atty fee). if i enter the value that it should be, it
gives a value of 0 or 1.
This is what i have:
Expr1:[atty fee]=IIf([CurrentBal]>1000,250,100)

also, i need to figure out how to return a value that is a percentage of
CurrentBal, i.e. [atty fee]=IIf([CurrentBal]>1000,[CurrentBal]*0.1,100)

thanks!vicki
 
okay i have corrected the first issue by including [atty fee] in a referenced
table [FEES] with fields: [court fees] and [service fees] (i'm filing
lawsuits)...but still having issues with the percentage calculation. and now
i can no longer pull the court and service fee fields, because they link to
atty fee which is not working. Please Help!!
I have modified my initial post below to reflect only the remaining problem.

alavaz17 said:
i am using access 2002. i have a query(query 2) that is pulling a calculated
value (CurrentBal)from a previous query(query 1). in query 2, i then perform
an IIf calculation (atty fee)based on (CurrentBal). i need to figure out how to return a value that is a percentage of CurrentBal,
Click to expand...
i.e. [atty fee]=IIf([CurrentBal]>1000,[CurrentBal]*0.1,100)
 
Back
Top