Problem with append query

[fazee]

hi
i am constructing a append query nd facing following problems.
1- if destination table is empty no record append to destination table
2- after place a record in destination table records are append but each time more records are appended then the orginal no from source table each time no of records increase perhaps multiplication of records


plz help

faisal iqbal ch

 

[neileg]

Not much information to go on here. You need to explain in more detail.

When I consruct an append query, I do it as a select query first and view the data in the query results to make sure I get what I expect.

 

[fazee]

i think problem is with destination table because when the destination table is empty o rows are inserted and if i place a dimmy record in destination table then this query append right no of records but when next time i run query its append 4 times of current records i.e if there were 4 records in source table then it will append 16 records next 64, then 256 and go on

 

[Rabbie]

It would be very helpful if you coul post the SQL of you query so we can see what it is doing.

 

[fazee]

INSERT INTO [transaction] ( [Date], member_id, Com_id, Dr )
SELECT reciepts.Date, reciepts.Mem_id, reciepts.Com_id, reciepts.Amount
FROM reciepts, [transaction];

 

[Rabbie]

DATE is a reseved word in Access and shouldn't be used as a a field name. Try changing it to recDate or tranDate and see what happens