ACCESS - INSERTING DATA IN A QUERY

[Kevsim]

My Question is -
I have a Query, made up of 4 different tables and want to update them all at the same time.
When I enter the data for table 1, within the Query, it may already contain the data I am typing in, can the data be typed in and within the Query Criteria, make a Statement to ignore the data if it alredy exists in the table. This would also apply if any other tables contain the same data as being typed in.
I would appreciate your advise.
Regards,
kevsim [sig][/sig]

 

[Robertd]

Hi Kevsim,

try adding something like,

where yourCriteria And table1.fieldN <> table2.fieldX

as i don't know what your queries are you will have to impliment this to suit.

HTH
[sig]<p>Robert Dwyer<br><a href=mailto:rdwyer@orion-online.com.au>rdwyer@orion-online.com.au</a><br>[/sig]