How to find the most recent transaction date of a unique item

[WSgarcich1]

MS Access 2016

Hello! I have an access table that records dates of a transaction and I’m trying to create a single query that will show the most recent date of a specific transaction. I cannot give the exact details of what my data – so will try to explain what I’m trying to doing with other examples:).

Say I have a table that lists dogs and a record of the date they had a bath. I need to maintain the historical record of the dates they had a bath. So I have Spike, Jaws, Princess, Thumper, and Buster. Each of them have multiple date entries of each time they’ve had a bath. I also have Tiger and Piglet, but they don’t get their baths with us anymore. So- they’re not active customers. I cannot delete their historical bath dates.

Is it possible to create a query that my boss can pull that will show each current customer/dog and the most recent date that they had a bath? And then – is it possible, in that same query to calculate what date they would be due for a bath again…say 30days from the date of their most current bath date?

 

Thank you in advance for any help! And thank you for playing along in my make believe scenario!

Reply | Quote

[Author]

Posts