Hi All,

I have a problem in appending a query..from One table to other..For Ex:

Table 1 contains the data of the 11 Months...and i receive the Table 2 data of total 12 months which does not have a identification on month..but i have write a unmatched query type and find new data and should update with that the data which is found new is of new month...Here the problem is i can write a append query but i don't know how to insert the date while writing a append query...for a new values what i need is while running the append query is show get a POP input box and when it founds the new data then the data should be updated with Input date of what i have given..Please help me at the earliest...as i can complete my project easily...

Note:- You can take any two tables as examples and insert a column as month and can try the solution and can write a append query which gives a Input box.

Thanks
Surya