J
James
How do you copy a group of records and then paste them in the same table
using a form?
I would like to select a weeks worth of information and paste it into the
next week with a certain date range. I guess I could setup one table which
would be the "template." That table could be changed and updates and then I
can run an append query to add it to the other table each week. I could do
the append query but I don't know how to tell it what date to use.
Lets say that the "template" is a table that will have one a day field to
store the value for each day of the week (1-7). If I want to append the
template to start on Monday Feburay 20, 2006 (fldDay = 1) through to the
following Sunday (fldDay = 7) how do I tell access to assign the dates.
using a form?
I would like to select a weeks worth of information and paste it into the
next week with a certain date range. I guess I could setup one table which
would be the "template." That table could be changed and updates and then I
can run an append query to add it to the other table each week. I could do
the append query but I don't know how to tell it what date to use.
Lets say that the "template" is a table that will have one a day field to
store the value for each day of the week (1-7). If I want to append the
template to start on Monday Feburay 20, 2006 (fldDay = 1) through to the
following Sunday (fldDay = 7) how do I tell access to assign the dates.