If/And Statement

[trans]

I know how to use the If/And statement nested together in Excel. Is it
possible to use this same type of function in Access? If so, do I write the
same formula or is it done in a different way?

Thank you.

 

[BruceM]

You most likely would use IIf instead of If, and the syntax for And is
different than in Excel. See Help for information about IIf and And. To
receive specific suggestions you should post a more specific description of
what you hope to accomplish. In general it would be something like this
(all on one line):
IIf([Item1] = True And [Item2] < 100 And [Item3] <> "Something",[Text1] =
"Yes!",[Text2] = "Nope")
Use an = sign before the expression in a text box; in a query precede it
with something like:
MyNewField: IIf...

 

[fredg]

I know how to use the If/And statement nested together in Excel. Is it
possible to use this same type of function in Access? If so, do I write the
same formula or is it done in a different way?

Thank you.

Why don't you share with us what it is you are trying to accomplish
and where, such as in VBA, in an Access control, in a Query, etc.
A brief example would be nice.