Homework adv access

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
 
J

John W. Vinson

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
Click to expand...

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]
 
G

GARCIASREMODELING

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]
Click to expand...
 

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

IFF (In A Querry) 2
Access My Expression Contains Wrong number of arguments 0
CrossTab Help! 6
I need help using the IIF function 2
Access 97 - Simple Calculation 12
Like IIf statement that needs results to work with even getting bl 9
Nesting IIf Statements in Microsoft Access 2000 4
IIF Function Within A Query 6

Top