Append query not working correctly

[swaroop1012]

Hi,

I am sorry for posting the same problem again but some replies to my pld problem said i dint explain the problem well. so i am making it a bit detail here.

I am working on a database where I need to take some data out of one table (say Table1) and append the data onto other table (sat Table2).

I created an append query, delete query and update query for deleting the records in Table2 every time i run append query, append the data to Table2 and update records in Table2 for some manipulations.

I am running all these queries from the query window directly. now what i need is to run the queries from a form. The append query depends on two date fields in the form and must append the records between the dates onto Table2.

I created a form with two text fields for dates, and a command button to run the queries. I used a macro to open all the queries at a time once the command button is clicked. The delete query is working fine, but the append query is executed, it says "appended 0 records". I am sure there are records that must be appended.

I am not sure what the problem is. Can anyone help me in this issue.

Thanks in adavance.

 

[namliam]

If your database is designed properly you should need to use an append query to send the records from table 1 to table 2. Or update the records... Simply run one query ...

Also opening a new thread just for the sake of explaining better... better to re-explain in the existing thread... Which I think is here