I'm having some trouble with a query. I set up a query that looks at a status update table and let me know which entries have a update date older than 30 days. I need it to generate a report on vehicles that have not been inspected for over 30 days. The problem I am running into is that it does only show me vehicles with dates older than 30 days but, even if a new update has been enter for that Vehicle ID, it still shows the old status based on the previous date. I can't delete the old record as I need to keep a history of each update. Can anyone help with this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Query Help
- Thread starter Def7
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,171
- Office Version
- 365
- Platform
- Windows
Def7,
Is this related to the other question you asked here:
http://www.mrexcel.com/forum/showthread.php?t=381004
because the answer is going to be pretty similar. Are you just having trouble figuring out how to get the Aggregate Query to work? If so, just post back there and we can help you out with that.
Essentially, what you want to go is an Aggregate Query to return only the most recent record per vehicle. Once you have that, they apply your 30 day criteria to that.
Is this related to the other question you asked here:
http://www.mrexcel.com/forum/showthread.php?t=381004
because the answer is going to be pretty similar. Are you just having trouble figuring out how to get the Aggregate Query to work? If so, just post back there and we can help you out with that.
Essentially, what you want to go is an Aggregate Query to return only the most recent record per vehicle. Once you have that, they apply your 30 day criteria to that.
Upvote
0
Similar threads
- Question
- Solved
