Access 2003 forms

[Davah]

Having difficulty filtering data in form - Example 22,015 record database.
Right clicking on a field and entering *no answer* yields 474 records. Right
clicking on the field and entering NOT *no answer* yields 3014 records
instead of 21,541. Why doesn't the NOT contains yield the correct records?
The same happens with equals and NOT equals.

 

[vbasean]

you may have null values or empty strings?

 

[aaron.kempf]

uh, I don't think that you're account for nulls.

I would _EITHER_ use nulls or '*no answer*' because I think that in
the sloppy world of Access databases.. that is 'sloppy enough' to work
great.

Then, you would just search for nulls.

You either either
a) search for nulls _AND_ 'no answer'
b) search for nulls.

Which is easier? Honestly?

-Aaron

 

[Allen Browne]

See:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html