Create records

[James Tebb]

In Table One there are 2 fields - Start Date and End Date.
In Table Two I have 2 fields - Date and Event

I want to create a macro that looks at the start date and end date in table 1 and creates new records in table 2 - one for each date between start and end.


Does this make sense??

 

[Norie]

James

This might sound like a stupid question, why?

Isn't it possible you could end up with a whole load of redundant fields with just a date and nothing else?

Or do you have data for the Event field for each date?

 

[James Tebb]

I have data for each event that will need to be put in manualy. I just want to speed up the job by populating the table with the dates automatically.

 

[Norie]

James

Why not set up a form so that when the user adds a new record the date is taken from the previous record, or latest date?

By the way, where do you have this data?

 

[James Tebb]

Apologies my knowledge is poor
Thats exactly what I want to do. but how do I get it to recognise the previous date and return a new rcord with date + 1

 

[Norie]

Will the previous date just really be the maximum/latest date in that field?

If it is then you should be able to use DMax() to get the latest date and add 1 to get the next date in sequence.

You won't be able to do that in the table, you would need to use a form, and you might need a little bit of code.

PS I do mean a little bit - one line in the right place should do it.