Append range of dates

[Dheinze57]

I would like to add all the Tuesday dates for 12 months at one time to a
table. It can easily be done in excel, but I wish to automate it for others
to use in Access. Can it be done by using Append queries and or macros or
code? I could use a form for a beginning and end dates if necessary.

 

[freakazeud]

Hi,
why would you want to do that?
This value would be a calculated value and as a general rule we do not want
to store calculated values in tables. You can display them at runtime on
forms or reports if needed.
HTH
Good luck

 

[Duane Hookom]

I could see if you wanted to append schedule records to a table of scheduled
events, this might come in handy. There is a small sample "Recurring"
database at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.