Can't edit data in query

[Bonnie A]

Hi everyone. Using A02 on XP. This may be a dumb question but I have a
UNION ALL SELECT SQL query showing me all records from 3 tables
[tDistributions], [tDistributionsArchive] and [tDistributionsArchiveOld].
Why can I not edit any fields?

I receive an Excel file with uncashed check numbers, date mailed and payable
to. I have to search through all distribution records to identify which
distribution record's check did not cash yet so we can pursue payment.
Because the tables are old and inherited, my unique identifier is only unique
in 2 of the tables so there is a bit of searching. When we find the
distribution record, we need to type in the Check Number as that will trigger
the 'check not cashed' report to follow up.

I tried to add WITH OWNER ACCESS but I still can't type in the Check Number
field.

I cannot link the data, it must be searched and then I have to open each
table and 'tag' the record by typing in the Check Number.

Just wondering if I'm missing something easy or if I have to find another
way to identify which distribution record needs a check resent.

Thanks very much in advance for any help or advice.

 

[Klatuu]

You can't edit data in a union query. It would not know which table the
query field belongs to. You may need to use the union query to populate a
temporary table which you then could edit.