Show only records that are from yesterday in a daily query
Posted on 2004-09-29
There is a query that runs daily to fetch certain records from a linked table and appends them to a cumulative table. The query runs to find all records for the 29th (today) and appends them to a table that has been queried for the entire month. Unfortunately, sometimes today's query will contain some of yesterday's records. For example, if you ran the cumulative query for the 29th (includes all records from the 1st to the 29th) and then just the daily query for the 29th (supposed to show only records for the 29th) you will see some records from the 28th. These records from the 28th didn't show up on the cumulative query for the 28th but showed up overnight when the query is run in the morning for the 29th. (Don't know why! It runs on a linked table that we have no control over). How would I make just a simple query that shows all the records that were from yesterday but just didn't show up on yesterday's cumulative query: One that compares the cumulative query to the daily query. Is the unmatched query from the wizard right?