Search results

Well I have only one thing to say, Thank you! This worked perfectly it seems so obvious once its done and I sit and look at it. Once again, Thank you very much! :D :D :D

I've been tasked with another query. This one seems quite complicated. I have to find only entries that are standby with no callins. My database layout, Date|Day of Week|Employee|Classification|Hourly Rate|Type|Hours|Hours Paid|Shift|Value|Time|Section|Notes|Mileage|Meals| An example...

I think if your specifying which dates you want your query to be between the criteria Between #Date# And #Date# should work. An example would be Between #2002-01-01# And #2002-12-31# This brings up all my dates from 2002. You can change the dates to the ones your trying to query. Hope this helps.

Thanks muchly. This worked perfect, definatly wasn't something I would have thought of. It doesn't help that I have basicly no knowledge of MS Access outside of what I pickup on from forums and such. Once again. Thanks.

Well here is my problem I'm doing a time keeping database and have about 13,000 entries. Some of these entries are for Callins others are for standby. My problem is this, I've been asked to make a query that will find all standby entries that have a matching or corresponding callin entry. The...