Hi All Access Gurus
Got an issue with what I thought would be a simple select query.
On a form called frmMain, there are 3 text boxes that each contain a number.
The query is a group by and sum.
I want to only select the records that don't equal what is in any of the text boxes.
In the criteria I am putting the following:
<>[forms]![frmMain]![textbox1] or [forms]![frmMain]![textbox2] or [forms]![frmMain]![textbox3]
this does not work, however, if I enter the actual numbers in the criteria i.e <>"1" or "2" or "3" it works
I am stumped!
Please help
best regards
KC
Got an issue with what I thought would be a simple select query.
On a form called frmMain, there are 3 text boxes that each contain a number.
The query is a group by and sum.
I want to only select the records that don't equal what is in any of the text boxes.
In the criteria I am putting the following:
<>[forms]![frmMain]![textbox1] or [forms]![frmMain]![textbox2] or [forms]![frmMain]![textbox3]
this does not work, however, if I enter the actual numbers in the criteria i.e <>"1" or "2" or "3" it works
I am stumped!
Please help
best regards
KC