Search results

I tried now again the append query while I added manually the 1st record to the table and it works successfuly. If I delete all records, the append query didn't work. Any suggestions for that or maybe I must keep one record for the append to work?

yes exactly but honestly I don't know how to use DAO your help will be very much appreciated

I cannot use a simply query because the queried data needs to be stored in a seperate table, I tried an update query and append but it doesn't work. The second table has one additional field that will be filled from a form text box

Hello, I have an inquiry about using dlookup to retrive all fields from a table that are using the same criteria. Here's the table structure Table1: ID (Autonumber) Number Code Grade I have the following data: Number Code Grade 4 15 68 4 52 78...