a tough date/time question 1

[Newatprogramming]

Maybe for some!! I have table that is setup with date and time. In my query I only want ask for the date once in my criteria. [Enter a date]

The problem is I cannot make changes to the table and if do not ask for a particular time in my date/time I receive nothing.

Example.
[Enter a date] 9/10/2003 -- results BLANK
this works but I do not want to ask for the time.
[Enter a date] 9/10/2003 7:30:12 AM-- results will be whatever I was looking for.

Any help. This has been racking my brain.

 

[missinglinq]

Why can you not make changes in your table?

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin

 

[logicmystic]

What you need is a wild card for the time. The date and time are stored as you've noticed. Depending on your version of Access you can get away with something like this:

like [Enter a Date] & "*"
as the criteria expression in the query

HTH

N.

 

[Newatprogramming]

logicmystic your right on track!!

Thanks!!!!!!