Query to find the opposite of filtered items
Windows 7 64bit 
Access 2007
Hi I am working on a query for work and am struggling to find an easy way to filter out my information to find the desired result. The columns in my query are dolly number, date loaded, date shipped, and date returned. I can easily figure out which dollies have been loaded as they would have a date in the date loaded column and the other two are blank. Same with dollies that have been shipped as they would have dates in both the date loaded and date shipped. Dollies that are available to be used are the ones that I'm having a difficult time querying out. Each dolly will have multiple instances where they've gone through the process of being loaded, shipped, and returned so I just want to look at the last record for each one to see if it has a date entered in the date returned column. Any help would be greatly appreciated. Thanks
Reply With Quote
