Query Parameter!

[cap.zadi]

Dears,

I am looking to apply a Parameter in my Query in the field "ShiftID" where 1 = Day Shift & 2 = Night Shift.

so i fill up the criteria with [Which Shift?] and it returns the results for the required shift.

what case can be if some times we want to see the results for both together?

Please advise?



zee

[goodguy]

Make another query with criteria SHIFT = 1 OR SHIFT = 2.

[cap.zadi]

Sir, i am expecting in same query like if it works?

If put the value for 1/2 or just leave it empty and click so both shifts appear.

is the condition like;

[Which Shift?] OR "Both''

plz advise.

[alansidman]

Change your criteria to Like [Which Shift?] & "*"

If you leave the parameter empty when it appears then you will get all records. If you put in 1 then you will get only shift 1 and if you put in 2 you will only get shift 2 records.

Alan

[cap.zadi]

thanks for u kindness
it is done