Hey Everyone,
I need to make a query/s in order to complete the below task, but I'm not quite sure how to do it!!
I have a booking system for a business in access which records data like, customer information, staff information, and appointments etc. I have a growing amount of customer data and I want to set up an archiving system. So, basically - I want to move any customers who have not had an appointment in the past 5 years out of the main customer table, and into an archving table.
I have tried to do this - but I just dont know how!!
Any ideas?
Thanks
Andrew