Query not returning data

  • Thread starter Thread starter angela.gay
  • Start date Start date
A

angela.gay

I have a query that I want to return all data with a specific date.
The field I am trying to pull from is called GL Date and I was trying
to use the criteria as [Enter GL Date].. does not return any data. I
did the same thing in a different query for the column called Date
Sent and used the criteria [Enter Date Sent] and this one works. I
need help, I don't know why the GL Date one won't work when I set it
up the same exact way as the Date Sent one.
 
Angela,

A couple of suggestions.

1. Make sure the data in the column is actually Dates, not Dates and Times.
If you format the column for display as long date time and all the times are
00:00:00, you are OK, but if the field actually contains time values, then
you need to modify your query to something like: WHERE DateValue([GL Date])
= [Enter GL Date].

2. The second thing you need to do is make sure you have defined [Enter GL
Date] as a parameter for the query. If you right click in the grey portion
of the query design screen, and select Parameters, it will popup a dialog
box. Copy [Enter GL Date] into the first column and select Date/Time as the
Data Type.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
In addition to Dale's suggestions, you might want to try this...

Open the query in design view. Replace the parameter prompt with a date you
know is in the table. Run the query. Did it work?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top