Ok
Lets say I have a project, this project has 7 doors, and the 7 doors are two different products, one product's quantity is 4 (4 doors) and the other's quantity is 3 (3 doors)
So Tblproducts has 2 records
ProductID ProductModel Qty
1...
Thx for the reply
Look I will explain exactly what i want to do
I have tbl products with some records and each record has quantity field
let say 3 records and the sum of quantity field is 8
I want to append these 3 records to another table with 8 records (one record for each product quantity)...
Hi
I am trying to append data from tableA to tableB using an append query
The problem is every time i run the query table A have the same records from table b again and again even i didnt add new records in tableB.
it is like a nightmare