Homework adv access

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

Guest

the book says"to use the IIf functions to set the Monthly Due Field Value to
the Monthly Fee Value for MembershipStatus Field Values of Active and To zero
in all other cases" Can someone tell me what that would look like in the Zoom
Box so it will Calculate it correctly it keeps giving me errors
--goodegirl
 
the book says"to use the IIf functions to set the Monthly Due Field Value to
the Monthly Fee Value for MembershipStatus Field Values of Active and To zero
in all other cases" Can someone tell me what that would look like in the Zoom
Box so it will Calculate it correctly it keeps giving me errors
--goodegirl

No, for several reasons.

We don't give out homework answers. If you just parrot an answer without
understanding it, you won't learn anything.

We don't know the structure of your table.

We don't know the datatypes of the fields you mention.

John W. Vinson [MVP]
 
John W. Vinson said:
No, for several reasons.

We don't give out homework answers. If you just parrot an answer without
understanding it, you won't learn anything.

We don't know the structure of your table.

We don't know the datatypes of the fields you mention.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF function 4
Still unable to run successful query 2
IFF (In A Querry) 2
Help on Calculated Formula 5
crosstab problem 2
I need help using the IIF function 2
Access Query problem 1
qry FORMULA ISSUE 2

Back
Top