Table: Update
Fields: Cust_ID, Date, Update_Details
Basically, I have a table that consists of customers, the date they sent in an update, and details about the update. Since November the 1st, each customer (there's about 28 in total) should have sent in at least one update per day. So, in the update table there should be at least one entry (Sometimes there are more) per customer per day. The problem is that there are some days when the update wasn't recorded in the DB.
I need to develop a query that shows the customer and date for which there was no update entered.
Anyone got any advice or ideas? Thanks in advance.