Calculation field in query

J

John Vinson

can if statement be included in the Calculation field in query?
Click to expand...

Yes; use the IIF function. Open the VBA editor (by typing Ctrl-G for
instance) to bring up the correct help file, and search for help on
IIF. In essence, you'ld use

CalculatedField: IIF(LogicalExpression, ValueIfTrue, ValueIfFalse)


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

Split form 0
Turning off automatic calculation 0
Append Crosstab Query to Existing Table 0
Incone & Expenses Statement 0
Calculation Based on Dynamic Variables (What-if Scenario) 0
MS Project. Real progress of the project, % complete 1
Page numbering with Merged Document and IF statements 1
Insert Multiple Fields without Dialog closing between each... 0

Top