parameter not working

lipin

Registered User.
Local time
Today, 23:12
Joined
May 21, 2002
Messages
149
I have a table with test data, about six fields, only have 2 records in it trying to get a very simple query to work. Query returns all 6 fields, after prompting the user for the id# and the date.

The id parameter works fine tried it and the two records returned fine. Added the Enter the date parameter and it pops up fine but returns no records.

I have [Enter the date:] in the criteria line of date in the query. Tried just date parameter alone and it's not working.

What 's going on?
 
Not sure... I set up a test table and query with a Date/Time data type in one of the fields and a parameter for that field in my query. It works fine. Do you have your date field set up as a Date/Time data type?
 

Users who are viewing this thread

Back
Top Bottom