Append Events by Date

[jollofrice]

I have a series of events that have a start date and an end date. How do I write an append query to append an event to a table as an individual event for every day in the given range?

 

[pono1]

Assuming you are working with two tables, roughly (I may have the date format incorrect)...

INSERT INTO Table2 (EventName) 
SELECT Event
FROM EventTable 
WHERE Start_Date >= #dd-mm-yyyy#
      AND
      End_Date <= #dd-mm-yyyy#);

Regards,
Tim

 

[jollofrice]

Thanks, I'll give it a shot.