Hi,
So I am looking for a way to have the query only show the latest appointment date and not show all booked
I have these fields...
Customer ID | Date Booked | Appointment Date | Appointment Time
123|24/07/2020|03/08/2020|9:00
123|27/07/2020|08/08/2020|11:00
123|07/08/2020|13/08/2020|9:45
Just want to show the latest appointment Date - is that possible?
So I am looking for a way to have the query only show the latest appointment date and not show all booked
I have these fields...
Customer ID | Date Booked | Appointment Date | Appointment Time
123|24/07/2020|03/08/2020|9:00
123|27/07/2020|08/08/2020|11:00
123|07/08/2020|13/08/2020|9:45
Just want to show the latest appointment Date - is that possible?