Search results

hahahaha

thanx but how to do that on the above example?

How should I have a result that shows only the records NOT already in the table I want to append to ? The SQL code is as follows: INSERT INTO Orders ( Product_ID, Customer_ID, Order_Date, quantity, Unit_Price_Sale, Amount_Sale ) SELECT DISTINCTROW tblorderproduct.Product_ID...

SOLVED ! I just made a delete query with this code and it worked ! DELETE Orders.*, (SELECT COUNT (*) FROM Orders AS L WHERE (L.Order_Date & L.Customer_ID = Orders.Order_Date & Orders.Customer_ID) AND (L.Order_ID <= Orders.Order_ID)) AS Expr1 FROM Orders WHERE ((((SELECT COUNT (*) FROM...

world known Dr. Lichun Huang is my teacher in auriculotherapy. I diagnose from the reflection points of organs located on ear and hand with electro acu device and treat the corresponding point where problem is found with electro magnetic waves of certain frequency and voltage. I can instantly...

Thank you. I have been active in chemistry during my college studies especially in practical experiments with different chemicals.

Its so kind of all of you people. I certainly admitt that AWF is the best form.

so kind of u but i have to ask more so kind of u but i have to ask more

so kind of u but i have to ask more

I dont have proper words to thank you Pat Hartman and The_Doc_Man I have the query as follows: INSERT INTO Orders ( Product_ID, Customer_ID, Order_Date, quantity, Unit_Price_Sale, Amount_Sale ) SELECT DISTINCTROW tblorderproduct.Product_ID, tblorderproduct.Customer_ID, tblorderproduct.Date...

no dear

hi, I am homeopathic doctor with diploma from UK in auriculotherapy with latest laser devices. and much than that I am an astro palmist, getting time of birth and date of birth from hand and then I make entire chart from just palm only accurately. cheers

all the other things are according to my needs. but duplicate records are making my head to blow

i have tried but no records are added while doing so

thanx for reply. actually, C-Add query appends record from subform frm customer sale and the customer in sub form are addedd each time in duplicate, when query is called. just run it and check. what should i do. plz help

so kind of you. But how i should do it

hi, I have a database attatched with from name 'Main' , and when I run append query named 'C-Add' from the form through clicking button 'Process' then,,, the query appends the previous order's enteries also. i.e they are copied teach time. how can i prevent this. plz help. urgent

hello