About Append Query.

[abzalali]

Dear Expert,
How to check same data exist in destination table before append data using Append query, In my "Order" table having filed (InvoiceNumber, CustomerName, FishName, Quantity) and my another table is "DiveCrew", there have same filed.

I just need to check before append data to destination table (DiveCrew), If destination table contain same (InvoiceNumber, CustomerName, FishName) then it will append only those data are not matches. How could I do this?

Please help me.

Thanks
Mir

 

[Cotty42]

Set up your query with linked tables "DiveCrew" and "Order" linked by "InvoiceNumber" and set the join parameter to All records in "Order" Only Matched Records in "DiveCrew".Then set criteria for [DiveCrew].[InvoiceNumber] Is NullThat should do it.Dave

 

[abzalali]

Dear Sir,
Where I placed [DiveCrew].[InvoiceNumber] Is Null in Append Query?

Thanks
Mir

 

[Cotty42]

Your Append Query needs to have the two tables reference ("DiveCrew" and "Order").

Set the Query as an AppendQuery to add the records to the "DiveCrew" Table.

Your Query will need to have the following fields from table "Order":
InvoiceNumber, CustomerName, FishName, Quantity
These are to Append to thecorresponding field in "DiveCrew"

Also Add Field "InvoiceNumber" from Table "DiveCrew" - Leave the 'Append To:' box Empty and in the 'Criteria' Box enter Is Null

Hope this Helps

Dave

 

[abzalali]

Sir,
I did this as same just before but it will not append any rows.

Thanks
Mir

 

[Cotty42]

Change the Query type to "Select" and go to Datasheet View. Does it show any records - If Yes then you must have some locks or data conflicts which prevent you from appending records to the table.
If No - remove the 'Is Null' criteria and view in Datasheet view again. If all records from Table "Order" have a corresponding record fro table "DiveCrew" then there are no new records to add.