Search results

I have been working access 2003 for 6 years and i am very impress with its feature as you can use custom menus and give your application a professional look, create mde etc now i want to move to access 2007 which has some new features like runtime module etc but access 2007 dont allow me to...

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

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...

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...