I have a database to handle donations to a non-profit. There's a table for Thank-You letters. Here is an abbreviated field list:
DonationID (Long)
Name (Short Text)
Address (Short Text)
Amount (Currency)
NonCashItems (Long Text)
Paragraph1 (Long Text)
Paragraph2 (Long Text)
Currently, I clear the table, then fill it with everything except Paragraph1 and Paragraph2 using an append query. This is working fine.
The problem occurs when I try to fill paragraphs 1 & 2 using an update query, getting the data from another table. I want to do this in 2 passes (first append then update) because getting the paragraph data is complex, depending on the type of Thank-You letter.
When I run an update query to fill in the last 2 fields, it gives me an error about not being an updatable query. This happens whether I use a left-join query to get my paragraph data or use a (sub-query) in the "Update To" cell to get my data.
If, for testing purposes, I simply update the 2 fields to "Test1" and "Test2", it works just fine.
Why can I do the append query and it works fine, but when I do the update query I get the updatable query error?
Thanks...