Query by Form (QBF)

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?
 
A

Allen Browne

Aything you type into the Criteria row in query design view applies to the
field above it.

You therefore cannot enter:
[Forms]![qbf_form]![Client Last Name] Is Null
as the criteria.

You can type the expression into a fresh column in the Field row:
[Forms]![qbf_form]![Client Last Name]
and then enter:
Is Null
as the criteria below that.
 
C

Ceiridwyn

Interesting. Your reply makes sense, however I am baffled that I found the
source to perform this in the first place on Microsoft Help. Thanks again.

Allen Browne said:
Aything you type into the Criteria row in query design view applies to the
field above it.

You therefore cannot enter:
[Forms]![qbf_form]![Client Last Name] Is Null
as the criteria.

You can type the expression into a fresh column in the Field row:
[Forms]![qbf_form]![Client Last Name]
and then enter:
Is Null
as the criteria below that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Ceiridwyn said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top