I have a query created by the "Find Unmatched" query that lists items
in a table that were not selected by another query. The Query does
what it needs to do, but I can't edit any of the resulting fields the
way I can with other Queries. E.g., the "Description" field is a memo
field, but when I try to click on the text and edit it, I get the
fimiliar "bonk" sound, telling me I can't edit this.
Here's the SQL:
SELECT tblSpecItems.Subsec, tblSpecItems.Description,
tblSpecItems.Index
FROM tblSpecItems LEFT JOIN qryJobSpecsAll ON tblSpecItems.id =
qryJobSpecsAll.id
WHERE (((qryJobSpecsAll.id) Is Null));
Thanks!
Rich