Need help on Iff Statement

A

Aamer

I want to use IFF statement in a querry but so far am unable to figure out
how to do it.
If someone could guide me I will be greatful.

following are the fields in a table / querry

Trans Id - Customer Name - Description - Qty - Price - Entry Type

The value for Entry Type has 3 options - Sales, Purchase, Returnable Item

If in an entry the value for Entry Type is Returnable Item, then other
entrys must show skipping the Returnable Entry

I tried using the following statement in a querry but it does not work

=IIf([Entry Type]="Returnable Item", "Returnable item", is null)


please Help me fix this problem


Regards
 

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

Subject: Need help on Iff Statement 1
Help Me Fix This Querry 1
VBA Coding Help - Need to edit field 1
Need help to Simplify a Complex Calculation on a Form 0
How to use an IFF statement for validation rule 2
problem with iff statement and is null 1
Using Lookup field in a table to help calculate a Total 1
Insert statement getting "too few parameters, expected 4" errors 1

Top