UniqeValues property

  • Thread starter Thread starter Focus
  • Start date Start date
F

Focus

I have an updatable query based on some tables.
adding to this query a query with UniqeValues property (distinct)
reflect my whole query to be unupdatable.
is there a way to includ an UnUpdatable query and still be able to updat
other tables fields in query?

thanks
 
By using the UniqueValues property, you've disconnect the results from any
specific row(s). Let's say you had several people (rows), each with the
same address field value (all live at the same address).

If you queried for UniqueValue of address, how would you know WHICH of the
people's rows to update?
 

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

Similar Threads

Non-updateable query issue 24
filter form based on subform 2
Editing Data in a Query Containing 2 Tables 2
Access Updating inventory levels 0
Counting multiple memberships 1
Query not updatable..... 4
Join queries now not updateable. Need HELP 2
Create Table from a Form 1

Back
Top