Hi
I have a table of customers and appointments.
How can I use a delete query to delete costomers from the database who have not made an appointment for more than a year?
Thanks
Keith
Hi
I have a table of customers and appointments.
How can I use a delete query to delete costomers from the database who have not made an appointment for more than a year?
Thanks
Keith
In the delete query have a criteria for the appt date field where the date is less than 1 year from today. You could do this a few different ways. One way would be to simply use Date() - 365. You could also use the "DateAdd" function.
Thanks John, I did use the Date()-362