Can I update a select query using an update query?

K

kfng

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top