Hello, I am using Ms Access 2003. I have a table with 4 fields
RecId (AutoNumber), FirstChq (Number), LastChq (Number), ChqRunDate (date). I want to creat auto records in another table with two fields ChqNum and Dated for each cheque number. Example if FirstChq =50 and LastChq =55, instert 50, 51, 52, 53, 54 and 55 as ChqNum. Is it possible? Thanks.
Sorry, that wasn't an answer to my question. I know you want to append new records. I am asking:
Do you record any other data other than number and date in your new table?
Do you ever edit the dates or numbers of data in this table?
Aha! That's fine then. In that case, my code in post #2 applies.
Just so you know, if you were not storing information specific to individual cheques then I would have said that you should dispense with your table and generate the information at run time using SQL (i.e. not store the individual numbers, just display them when needed).