Query by Form

[Guest]

Hi,

I am trying to follow the technique detailed in the following link:

http://support.microsoft.com/kb/304428/EN-US/

In particular:

"NOTE: When you type the criteria, make sure that you type the entire
criteria in a single Criteria field; do not split the criteria by placing the
'Or' section on a separate row."

Every time I try and do this, when I save my query it is all in one criteria
field.
I then try and run the query and when I open the criteria in design view,
the second part of the criteria (Is Null) is in a new field (I don't know how
to explain this).

Bottom line is I can't get the technique to work and therefore can't get it
to work in my database.

FYI, I am using Access 2002 SP3 / Windows XP Home.

Can anyone suggest a better tutorial or explain why the criteria won't save
all in the one criteria field.

Regards


Gary O

 

[Pat Hartman\(MVP\)]

I have also run into problems with the QBE "rewriting" my criteria
incorrectly in rare cases - usually having to do with totals queries that
need Where clauses rather than having clauses. The only solution I have
found is to correct the problem in SQL view, save the query and NEVER open
the query in QBE view again. I usually put a little note to me in the
description field to remind me.