I have 100 clients who all have several appointments. I want a query that shows the all clients over 40 and the date of their last appointment. Can anyone help me with this please?? Thanks!!!
I have received a lot of help here, I would like to help if I can...
Make your query a totals query, then in the "Appointments" column on the "Totals" line instead of "Group" choose "Last"
I hope that is correct.
Thanks!!!
