Help with query criteria

R

Randy

I have a query that Ken Snell helped me with. It detects missing dates in
my employee timesheet db. My query has a field of [D] form tbl "Q", a field
of [FirstDay] where a date was entered indicating the employees first day of
work for the season, and [LastDay] for the date the employee was laid off
for the season, both from tbl "Q". I also have two fields of [EID] one from
tbl "Q" and one from tbl "W" I need to restrict the query to the
[FirstDay] up until I have entered the [LastDay] I have created a criteria
entered in the field [D]. (Dates). >=[Q].[FirstDay] And <=[Q].[LastDay]
It does not work as is. If I enter >=[Q].[FirstDay] I do get the dates
from the first day forward which is great, but I need the query to stop at
the point when the [LastDay] is entered. Thanks...Randy
 
D

David S via AccessMonster.com

What does it do when it "does not work"? Does it not return any fields, or
does it seem to ignore the last day and display records it shouldn't?
 
R

Randy

I mean the following >=[Q].[FirstDay] And <=[Q].[LastDay]
does not produce any results. Only the headers are shown.
This query >=[Q].[FirstDay] does work giving me results from the date
entered in the [FirstDay] to the last day entered.
 
D

David S via AccessMonster.com

Sorry for the absence - been busy here at work. I'm still not quite I
understand - can you post the SQL for the query?
 
Top