TimboWalker
New member
- Local time
- Today, 05:28
- Joined
- Dec 29, 2010
- Messages
- 2
Hi
I am pretty new to Access, and want to be able to autocreate dates in a calendar table for a payroll database that I am creating. If possible, I would like to be able to use a drop down list for weekly or monthly, and depending on this selection, create either 52 dates adding on to the first date for weekly (i.e if first date is 2nd January, 2011, auto create 9th, 16th, 23rd etc) and if selection is monthly, autocreate 31st Jan, 28th Feb, 31st March etc)
I know that it would be easier to buy software, but I work from an offshore Island, and there is not a great choice of cost efficient software available, so looking to do some basic development myself! Thanks in advance.
Tim
I am pretty new to Access, and want to be able to autocreate dates in a calendar table for a payroll database that I am creating. If possible, I would like to be able to use a drop down list for weekly or monthly, and depending on this selection, create either 52 dates adding on to the first date for weekly (i.e if first date is 2nd January, 2011, auto create 9th, 16th, 23rd etc) and if selection is monthly, autocreate 31st Jan, 28th Feb, 31st March etc)
I know that it would be easier to buy software, but I work from an offshore Island, and there is not a great choice of cost efficient software available, so looking to do some basic development myself! Thanks in advance.
Tim