New Records in a Table

[q582gmzhi]

Hi,

I need to create 12 new records in an existing table (one record for each month of the year)

Once I have created the new records, I then need to:

1. Add the dates for each month into a date field for each of the 12 records (ie: 01/01/2005, 01/02,2005, etc)
2. Populate the new record fields with data from another table.

How would I go about doing this?

Any help would be welcome.

Regards

Daz....

 

[Mile-O]

What do you think doing this will achieve? By adding the date field for each date for each record does this mean you have fields like Date1, Date2, Date3, Date4, etc?

 

[q582gmzhi]

Hi,

Long story but here goes.

I have created graphs from within Access. Graphs run from a crosstab query and data is grouped by month (Jan - Dec)

Graphs then display results by month - this all works fine.

We now need to show target line on the graph. Target data is kept in a table and is for the year not the month. (The target figure is the same every month - Flat Line on graph)

So I need to create 12 records into the existing table that the crosstab uses and for each new record add the data from the target table and add a date.

So I need to be able to:

1. Add the dates for each month into a date field for each of the 12 records
ie:
New Record 1: DateField = 01/01/05
New Record 2: DateField = 01/02/05
New Record 3: DateField = 01/03/05
2. Populate the new record fields with target data from another table.
New Record 1: TargetField = 85 (Data from Target table)
New Record 2: TargetField = 85 (Data from Target table)
New Record 3: TargetField = 85 (Data from Target table)

When this is done the graphs will then display the original results as mentioned above plus a target line because we have added the new records and target data.

Thanks

Daz....