Single Table Query, Pulling multiple fields each with specific criteria.

[bigchicagobob]

Hi all,

I am attempting to pull multiple fields from a single table. I need to pull any data that has the following:

[ShipCode]= "code1" "code4" or "code5"
Of those three codes, with an [estimate]="E" and a [flag]="p" and [DueDate] within 5 days before yesterday.



When I attempt to use the code below I receive...

Unconfirmed: IIf([ShipCode]="code1" Or [ShipCode]="code4" Or [ShipCode]="code5" And [Estimate]="E" And [Flag]="P" And [Due Date]<=(Date()+4),"Not Confirmed",Null)

This results in the correct ship codes of only [ship code]= "code1" "code4" or "code5" showing... but i get a whole assortment of values from the [estimate] field, [flag] field, and [due date] field.

I am using MS Access 2010 on windows 7. Thank you,

[ssanfu]

You need parenthsis around the "OR" values : ([ShipCode]="code1" Or [ShipCode]="code4" Or [ShipCode]="code5")

Try:

Unconfirmed: IIf(([ShipCode]="code1" Or [ShipCode]="code4" Or [ShipCode]="code5") And [Estimate]="E" And [Flag]="P" And [Due Date]<=(Date()+4),"Not Confirmed",Null)