Week and Date Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a table with the fields "week # "and "Date". The Data
I'm using Access for is collected the same day every week for X number of
weeks starting on pretty much any day of the year. i.e. every Wed. for 7
weeks starting on 11/3/06 or it may be every Tues. for 10 weeks starting on
10/5/06. I want to have my data base calculate the date for week 2 week 3
etc. until week X. It doesn't matter what day of the week it actually is.

Let say at the switchboard I'd like to have a Macro button that sets up a
form that I enter the number of weeks and the start date then Presto! I've
got table.

I've set up Macros before in access and built some simple VBA code to do
some simple things. I've also put some more complicated code in that I got
some where else then figured out what it did and tweaked it to my needs.

What's the simplest/best way to do build this table as I've described
specifically the presto part .
Kurt Dally
 
Hi,
why would you want to store this data within a table? Maybe you can clarify
your main goal a little more. You can easily do these calculations at runtime
with the DateAdd() function. Since these will be calculated values you
normally would NOT want to store them in table fields.
HTH
Good luck
 
Back
Top