Forum home » Delegate support and help forum » Microsoft Access Training and help » Iif Statments
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Iif Statments
Resolved · Urgent Priority · Version 2003
Reply Wed 26 Nov 2008, 08:41Delegate Vinay said...
Vinay has attended:
Access Intermediate course
Access Advanced course
Excel Intermediate course
Excel Advanced course
Iif Statments
On a query I got a field called Current Status which displays a drop down list on the following possible answers In Progress, New, Pending PR, Pending OS and Complete.
I would like to know which orders are complete and which are incomplete.
I have used this statement but all i get is just the complete orders.
iif[CurrentStatus]="Complete","Complete","Incomplete")
But I want the user to select either complete or incomplete and then the data will come up. of that particular order wether its complete or incomplete.
Please Help ?
For upcoming training course dates see: Pricing & availability
RE: iif Statments
Hi Vinay
Thank you for your question. One approach might be to have two queries - one that finds records where the status field matches "complete" the other where the status field criteris is "not complete" i.e everything else.
Let me know if this doesn't answer your question or if you have any other questions.
Kind regards,
Andrew
Tue 2 Dec 2008: Automatically marked as resolved.
|