conditional criteria in query - beginner question

[Hosacans]

Hi All,

I'm stuck on a query. I'm trying to select records based on their stock position and also based on location. if the loc_no is less then 10, i only want records with more than 50 units. then if loc_no is >10, it can return all records. i'm using Access 2000, please help.

here's what i got so far:

SELECT BASE_Main_Refill_with_ST.Style, BASE_Main_Refill_with_ST.EOH_U, BASE_Main_Refill_with_ST.Loc_No
FROM BASE_Main_Refill_with_ST
WHERE (((BASE_Main_Refill_with_ST.EOH_U)=IIf("Loc_No"<10,50)));

thanks
H

 

[PHV]

WHERE BASE_Main_Refill_with_ST.EOH_U>50 ORBASE_Main_Refill_with_ST.Loc_No>=10

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

Oops, sorry for the typo:
WHERE BASE_Main_Refill_with_ST.EOH_U>50 OR BASE_Main_Refill_with_ST.Loc_No>=10

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Hosacans]

FANTASTIC!!!

THanks so much PHV