Re: Can I update a select query using an update query?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This article explains how to understand key violations, lock violations,
validation rule violations etc:
http://allenbrowne.com/casu-19.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"kfng" <kfng@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E1040378-6F09-4750-9186-446FE38F99D6@xxxxxxxxxxxxxxxx
I have a select query (Q1) based on another two select queries(Q2:
involving
2 tables with one-to-one relationship and Q3:involving 3 tables with
one-to-many relationship between each table). Now, I have a set of
criteria
which is applied to the primary key field of one of the tables underlying
Q2
and Q3) and based on this criteria, I would like to update a yes/no box in
Q1
so that they will all be checked "yes". I created an update query to do
that
. It seems that only a few records got checked and then the remaining
records even though fulfiling the criteria remain unchecked. When I tried
to
run the update query, it keeps telling me that I have a key vilolation and
I
can't update the records.

I'm new to Access and I know the way I'm doing this may be clumpsy so I'd
appreciate any better way to do this updating thing. Thanks.


.