if/then statement in a query a question

[soniaariana]

am trying to write an if/then statement. I have this so far"
=IIf([Tax Escrow]="No",[Taxes]/12). It keeps giving me errors. I a
trying to get an empty field in a table labeled "tax pmt" to calculat
by the following: if the [Tax Escrow] field is check marked "No" the
divide the [Taxes] by 12. Any suggestions

 

[___]

Not sure, but you could try
=IIf([Tax Escrow]=0,[Taxes]/12)

HTH

 

[Douglas J. Steele]

Already answered in another group to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

I'm unable to tell how you're posting to this group: it looks as though it
might be through a web interface. If that's the case, I'm afraid I can't
offer any advice as to how to multipost. If you were using a proper
newsreader (or even the Microsoft web interface), you could type the names
of the various groups into the Newsgroup box, separating them with commas.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups. (In fact, at
http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp
Microsoft suggests that "One group will suffice")