Not an updatable query???

[JNana]

I have a query based upon several other queries. I am wanting to update the
final query, but get the message "Not an updatable query?"


Query 1 - Basic query listing control numbers with their payments. In
order to avoid duplicates, I created Query 2. (Query 2 is updatable)

Query 2 - This query eliminates my duplicate control numbers and payments.
I added 2 fields, 95% of payment and 5% of payment. This is also updatable.

Query 3 - Created so that 95% and 5% fields do not print - Not Updatable.
Why?

Can you give me some guidance? I am not sure where I need to be looking for
this one.

Thanks in advance,
JR

 

[Guest]

This is a very complicated subject. I suggest that you open up Access Help,
go to the Find tab, type in "updatable" (lower case u) or "About updating
data", and then scroll down to "When can I update data from a query?" or "Why
can't I edit data in my form?". There you will find a lot of, possibly too
much, information on the subject. In a nutshell, if the query is based on one
table or tables with a one-to-one relationship, you will be able to edit or
delete records. If it is based on two or more tables with a one-to-many
relationship, you 'should' be able to edit or delete records. If you have
three or more tables based on many-to-one-to-many relationships, you will not
be able to edit or delete records. This is just the highlights. Help has much
more information.

 

[JNana]

Thank you. I will look again. In the help, I found the info regarding one
to one-which my queries are-and nothing else. I was thinking that it was
probably because I had some calculations in the second query.
JNana

 

[JNana]

I think I have "lost it" today. My tables are one to many; not one to one.
I have three tables.
I still don't understand why my first 2 queries are updatable and not the
third. They are all based upon the first query and same tables.

Thanks