criteria query

[flyfree]

I have fields with names and dates due for various licences.
I want the query to print out a specific name and licences due before
January 2009.
If I put the name in the criteria box and <#01/01/2009# all on the same
line nothing comes up.
If I step the dates down in the 'or' boxes, all the fields have future dates
in as well.
(Access 2000)

 

[Michel Walsh]

In the first case, it is probably because there is nothing due, before the
first of January 2009, for the name you typed.

In the second case, what is returned is all records that are either matching
the name you typed, either have a due date before the first of January, but
not necessary BOTH conditions at the same time.


Vanderghast, Access MVP

 

[flyfree]

The first case didn't even show the name and there were some dates that
should have shown up.

In the second case, how do I get both conditions at the same time?

 

[Michel Walsh]

That is the first case, where your record has to have and the name and the
date before January First.

If the name alone (without the date) criteria is missing records, it may be
that the name, in the table, is stored with unprintable characters. Indeed,
"Hello" and " Hello " are two different strings (even if, for a
human, they mean the same thing).


Vanderghast, Access MVP