C
cmiller
Reading many helpful responses on this site, but unfortunately none of them
seem to remedy my current issue.
Just learning Access, took a quick college prep course, got the basics. Now
I am expanding freelance. SO the scenarios is my test idea that I have
intent to apply on larger scale. I have a database with 15 records... lets
say reservations (tbl_reservations) for a hotel. Used a maketable to copy
that table because it gets updated often to cancelled or complete status. So
I filter out the 9 of those 15 reservations which are still in pending status
and make the new table (tbl_pending_reservation) from those. The next day I
append 4 more pending reservations from the reservations table and add then
to pending res table. but now 4 of the original 9 reservations are
cancelled. I perform an unmatched query to find the 4 listed as pending in
the pending reservation and listed as cancelled in the reservations table.
What is the best method of deleting the 4 records that are incorrect on the
pending reservation table. (keep in mind this is 4 records, but in the end
it may be 1000's of records.)
I appreciate anyone taking the time to respond as this may be a wonderful
example for others.
seem to remedy my current issue.
Just learning Access, took a quick college prep course, got the basics. Now
I am expanding freelance. SO the scenarios is my test idea that I have
intent to apply on larger scale. I have a database with 15 records... lets
say reservations (tbl_reservations) for a hotel. Used a maketable to copy
that table because it gets updated often to cancelled or complete status. So
I filter out the 9 of those 15 reservations which are still in pending status
and make the new table (tbl_pending_reservation) from those. The next day I
append 4 more pending reservations from the reservations table and add then
to pending res table. but now 4 of the original 9 reservations are
cancelled. I perform an unmatched query to find the 4 listed as pending in
the pending reservation and listed as cancelled in the reservations table.
What is the best method of deleting the 4 records that are incorrect on the
pending reservation table. (keep in mind this is 4 records, but in the end
it may be 1000's of records.)
I appreciate anyone taking the time to respond as this may be a wonderful
example for others.