My customer accounts are growing fairly quickly. Since Access will only allow 10k records, I need to start thinking about how to purge/delete inactive customers. I would like to see a last activity date on the customer record -- the date of the most recent order received. When displaying customer accounts, I would like to be able to sort by this date, so I can delete those with no recent activity.
Thanks!
Pat
Thanks!
Pat
Comment