I have a database that I am working on that I enter postage amounts from the month for numerous areas in the company (70 to be precise).
I have to enter data for every day, for every 'property'. I know that there would be a way to, at the beginning of every month, populate the table (tblPostage) with every day for that month. I.E. 12/1/05, 12/2/05, 12/3/05, etc.
How would you go about doing that? I figure with an Append Query but not sure exactly how to go about it.
I have to enter data for every day, for every 'property'. I know that there would be a way to, at the beginning of every month, populate the table (tblPostage) with every day for that month. I.E. 12/1/05, 12/2/05, 12/3/05, etc.
How would you go about doing that? I figure with an Append Query but not sure exactly how to go about it.
