Criteria for Query

[Bob Barnes]

If I needing Manufacturing Shift data,
in my Query grid, i can use something like..
[Forms]![frmMain]![GoShift]....

....where "GoShift" is an unbound textbox on the Form "frmMain".

So, when "GoShift" is 1 or 2, the Query returns data for the Selected Shift.

If I leave out...
[Forms]![frmMain]![GoShift]...It brings in Both Shifts.

Can I use the same Query w/ a "[Forms]![frmMain]![GoShift]" type entry to
get all 3 possible "Shifts" = 1, 2 and Both???

TIA - Bob

 

[Ofer Cohen]

In the crteria section of the query you should have

Where [GoShiftFieldName] = [Forms]![frmMain]![GoShift] Or
[Forms]![frmMain]![GoShift] Is Null

So the criteria will either bring 1 or 2 As slected or all f nothing was
selected

 

[Bob Barnes]

Ofer - I had heard the solution was something like that...I knew the Power
of these Newsgroups.

Thank you - Bob

In the crteria section of the query you should have

Where [GoShiftFieldName] = [Forms]![frmMain]![GoShift] Or
[Forms]![frmMain]![GoShift] Is Null

So the criteria will either bring 1 or 2 As slected or all f nothing was
selected


--
Good Luck
BS"D

If I needing Manufacturing Shift data,
in my Query grid, i can use something like..
[Forms]![frmMain]![GoShift]....

...where "GoShift" is an unbound textbox on the Form "frmMain".

So, when "GoShift" is 1 or 2, the Query returns data for the Selected Shift.

If I leave out...
[Forms]![frmMain]![GoShift]...It brings in Both Shifts.

Can I use the same Query w/ a "[Forms]![frmMain]![GoShift]" type entry to
get all 3 possible "Shifts" = 1, 2 and Both???

TIA - Bob