2 Tables (1 Viewer)

[zezo2021]

I have 2 Tables in attached DB
Imported
And
AllDataSource

I want to create query append data from Table Imported to AllDataSource but if the the record is exist in AllDataSource Update the record in All Data Source Table

1- Append Data from Imported Table To AllDataSource
2- if record exists in AllDataSource then update based on Table Imported
3 - Shared field is ClientNo and Order No between 2 Tables

 

[theDBguy]

One query might be able to do it.

Update Query with Append

I can't say how often this situation comes up in real life, but an UtterAccess member wanted to find out how to run a single query that will...

thedbguy.blogspot.com

 

[zezo2021]

One query might be able to do it.

Update Query with Append

I can't say how often this situation comes up in real life, but an UtterAccess member wanted to find out how to run a single query that will...

thedbguy.blogspot.com

I solve the problem after viewing your post

Can you check the DB?
after the solution is applied
and give a feedback