News, tips, advice, support for Windows, Office, PCs & more
Home icon Home icon Home icon Email icon RSS icon

We're community supported and proud of it!

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

    Home Forums AskWoody support Productivity software by function MS Access and database help How to find the most recent transaction date of a unique item

    • This topic has 3 replies, 3 voices, and was last updated 2 weeks ago.
    Viewing 0 reply threads
    • Author
      Posts
      • #2337929
        WSgarcich1
        AskWoody Lounger

        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!

    Viewing 0 reply threads

    Please follow the -Lounge Rules- no personal attacks, no swearing, no politics or religion.

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

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.