C
Ceiridwyn
After typing my criteria in my query grid, Access automatically moves the
"OR" section and places it on the second criteria line. This produces
incorrect (unexpected) results.
And example would be:
[Forms]![qbf_form]![Client Last Name] or [Forms]![qbf_form]![Client Last
Name] Is Null
After saving and reopening in design view, I find the following:
[Forms]![qbf_form]![Client Last Name]
[Forms]![qbf_form]![Client Last Name]
The "Is Null" protion has been removed when the criteria was broken.
Can anyone help? I REALLY need to be able to specify certain criteria while
leaving others blank. Why is Access 2003 moving my criteria?
"OR" section and places it on the second criteria line. This produces
incorrect (unexpected) results.
And example would be:
[Forms]![qbf_form]![Client Last Name] or [Forms]![qbf_form]![Client Last
Name] Is Null
After saving and reopening in design view, I find the following:
[Forms]![qbf_form]![Client Last Name]
[Forms]![qbf_form]![Client Last Name]
The "Is Null" protion has been removed when the criteria was broken.
Can anyone help? I REALLY need to be able to specify certain criteria while
leaving others blank. Why is Access 2003 moving my criteria?