If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculation field in query
can if statement be included in the Calculation field in query?
|
#2
|
|||
|
|||
Yes.
"pei" wrote in message ... can if statement be included in the Calculation field in query? |
#3
|
|||
|
|||
On Fri, 25 Feb 2005 06:53:01 -0800, pei
wrote: can if statement be included in the Calculation field in query? 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving from xBase/Clipper | [email protected] | New Users | 1 | February 3rd, 2005 07:25 PM |
Building query parameters on a field derived from a calculation. | Bugman | Running & Setting Up Queries | 2 | January 19th, 2005 12:31 AM |
adding 2 fields including null entries | Jesse | Running & Setting Up Queries | 26 | January 18th, 2005 05:31 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM |