About Dennis Cassøe Expertise ASP in many areas, to include them all would not be possible but some examples:
Database access (SQL server, access)
Forms
Functions
Components like aspsmartupload, aspupload, FileSystemObject, jmail
And much more.
Can`t always garenty an answer, but will do my best.
Experience Have teached courses in ASP (for beginners)
Created
Knowledgebases
E-commerce applications
Ordinary updatable homepages
Organizations belong to Aarhus School of Business, Denmark
Freelance programmer
Education/Credentials Graduate student at the Aarhus School of Business, Denmark
Expert: Dennis Cassøe Date: 2/13/2004 Subject: schedule of dates for ms access form
Question Hi,
I am working on a database in ms. access and would like to know
what code would work to get a date schedule from the fields
"date started" and "number of repayments" assuming the intervals are fortnightly,
14 days.
The result I want is a list of dates presented in a list box type, commencing with a start date, and dates at 14 day intervals for the specified number of repayments.
I'm working with access 97, so if you can help me I would be appreciative. I'm fairly new to db design, so the simpler the better.
Thanks in advance.
rgw.
Answer Im not sure I understand the problem.
You want a date, and then you want 14 days added to it, and this should be done for a year?.
adate = 1/1/2004
'WRITE IT TO LISTBOX
For i = 26
adate = dateadd("d",adate,14)
'WRITE IT TO LISTBOX
next
