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?
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?