Find umatched query question

[Edward Armstrong]

Hi,

I have a find unmatched query currently in use in my billback design
program. My problem is, subsequent queries I create from this (and this one
too), are by default non-updateable.

Is there a way I can change this, so that I can update these records?

Thanks

 

[Michel Walsh]

Hi,



Change the beginning of the query to read


DELETE DISTINCTROW tableToDeleteFrom.* FROM table1 LEFT JOIN table2 ON
.... WHERE ...

assuming the "SELECT" query is:

SELECT tableToDeleteFrom.* FROM table1 LEFT JOIN table2 ON ... WHERE ...




Hoping it may help,
Vanderghast, Access MVP