Hello,
I have two questions:
1) Adding new field to existing table that was created from make-table query: The existing table does not have column DocNo, but I just add that in a make-table query. Now I want to include the DocNo in the existing table without loosing all previous data. Please show me how to make it work
Sample data:
DocNo -----------ID
85221088 042672430
52297028 043317625
85236121 061667436
85239274 133203909
85242941 134057211
85231470 200154224
85220968 222102790
85238147 231395000
85238147 231395000
2) Second question: Each month I have to append new data into this table. I need to remove all the old DocNo. But I don't know how to do it. For example, for ID= 231395000 would have a new DocNo next month, so the current DocNo=85238147 would need to remove.
Your input would appreciate.
thanks,