My title may have been a little misleading, or inaccurate, but I wasn't sure what to title it. Here is what I need to do.
I have created a series of queries from linked tables that give me a narrowed down recordset. The recordset will grow (by about 5 - 10 records a day), and will need to be analyzed on a daily basis. For the most part, based on the changes being made in the underlying linked tables, records are more likely to be added to the recordset than to drop off. Most of the values in the fields that qualified the records to be in the recordset will not change, thus the growing recordset. However, by viewing the records, a subjective decision needs to be made by a user as to whether or not the record needs to remain part of the recordset. Changes cannot be made to the data in the linked tables. Each record does have a unique value that I could link to.
My idea was to somehow be able to add a Y/N field to my final recorset query that could be edited such that the User could look at the records and mark the records that no longer need to be part of the recordset. Those records marked yes would be appended to a master table of records that no longer need to be analyzed. I would change the final query to include the master table, and would use it to exclude records from the daily recordset that have already been viewed. So basically, my daily query would be compared to my master table. The daily query would not show records that are a part of the Master table.
Can this part of my question (below) be done?
"My idea was to somehow be able to add a Y/N field to my final recorset query that could be edited such that the User could look at the records and mark the records that no longer need to be part of the recordset. "
While I was writing this question, I thought of a much better way to do it, but my question still stands.
Hubbs
Start Free Trial
