Forum Discussion

Yvonnebatfink406's avatar
Yvonnebatfink406
Copper Contributor
Oct 05, 2021

Access query last record by date

Hi, I have created a database with a customer table and an appointments table linking them with a relationship using customer ID. My appointments table has an appointment ID also, so that each appointment is recorded separately for each customer. I want my query to show me each patients appointment information from their last visit. When I have tried using max and last, its pulling up eg, their second appointment out of 3. And to explain, really need step by step instructions as I'm a novice and amazed my database works in the first place. When I finish work, I can add all the fields I have onto here to help maybe get an answer as to what I put in my query design. Grateful for any help btw.
access

5 Replies

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Oct 06, 2021
    It's impossible to offer specific suggestions based on general outlines, so this would have to be fleshed out with SPECIFIC table descriptions. Possibly the most effective way to do that is to upload a copy for someone to examine.
    • Yvonnebatfink406's avatar
      Yvonnebatfink406
      Copper Contributor
      Oct 06, 2021

      I believe I have done it thanks to scrolling through utube, just checking now that it's giving back correct information, really appreciate that you replied and hopefully the link might help anyone else. 😀
      https://m.youtube.com/watch?v=5cnwHyn4dnI