Forum home » Delegate support and help forum » Microsoft Access Training and help » Iif Statments

Iif Statments

ResolvedVersion 2003

Wed 26 Nov 2008, 08:41 Delegate 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 ?

Wed 26 Nov 2008, 10:41 Trainer Andrew said...

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.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

Iif Statments

Iif Statments

RE: iif Statments

Access articles

Access tip:

Using the Quick Access Toolbar in Access 2010