|
| 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
February 25th, 2005, 02:53 PM
|
|||
|
|||
Calculation field in query
can if statement be included in the Calculation field in query?
|
|
#2
February 25th, 2005, 02:58 PM
|
|||
|
|||
|
Yes.
"pei" wrote in message ... can if statement be included in the Calculation field in query?
|
|
#3
February 25th, 2005, 06:06 PM
|
|||
|
|||
|
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 | |
Linear Mode
