help on dates x

[x]

i have a report with query1 as record source.

the record source of my query1 are queries...

on the query1 criteria, it was set to accept input from
the user.

i put

=["Input Date to Print"]

it works fine... (if i wanted to print the date keyed in
and beyond....

my problem is, and what i really wanted to do is to select
only the dates matching the date the user keyed in.

when i remove the greater than sign from the criteria, the
query1 is getting 0 records..

heres a sample....
table:
07/14/2004
07/15/2004
07/15/2004

using >=["input date"] query criteria:

if the user key in july 15...its ok (shows only july 15ths)
it the user key in july 14... its ok ( shows july 14th and
15ths)

if i use =["input ....."]
= 0 records

can you please help me on this???

TIA

 

[John Vinson]

if the user key in july 15...its ok (shows only july 15ths)
it the user key in july 14... its ok ( shows july 14th and
15ths)

if i use =["input ....."]
= 0 records

I strongly suspect that your Table actually contains a date and time
portion. If you open the table datasheet and select the July 15
record, does it show something like 07/15/2004 11:21:28? (Note that
the Format of the field does NOT change its contents, merely how it's
displayed).

Either use a calculated field DateValue([fieldname]) to trim off the
time portion, or use a criterion

= DateValue([input date:]) AND < DateAdd("d", 1, DateValue([input date:])

to search all points in time between midnight and 11:59:59.99999 pm.