Re: Append Query to Create Repeated Records in Table

Thanks for the reply.

I was able to use DateAdd after creating two tables for frequencies,
which I needed anyway for choosing frequency during data entry. I
needed to have more than just one occurrence to repeat the event, kind
of like what programs like Calendar Creator would have to do. One of
the frequency tables just had the frequencies and their interval
strings. The other table had the FreqID from the first table and the
frequency iterations (52 records for weekly, 1 for yearly, 12 for
monthly, etc.). That way when I run a regular select query with the
main table of events and both frequency tables as sources, the records
automatically were created for the entire year. If I wanted to do more
or less than one year, I would just change the number of iterations in
the second frequency table. It works quite well.

I can go into more detail if anyone searching for this would like more
info.

Thanks again.
-B.

.