Need help on Iff Statement



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



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