How can I link weekly meetings to a calendar date?

[Guest]

I schedule recurring meetings on the basis of the week and the day. For
example: 1st MOndays, 2nd and 4th Tuesdays, etc. I then need to be able to
retrive those meetings by the corresponding calendar dates. (1st and 3rd
Wednesdays of April 2006 = April 5 and April 19.) Then I will be able to
merge with single occurance meetings, and sort in order by date and time.

Any suggestions?

 

[Douglas J Steele]

Not quite sure what you're looking for. Is it how to convert the 1st
Wednesday of April 2006 to April 5?

If so, take a look at my June, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[James A. Fortune]

I schedule recurring meetings on the basis of the week and the day. For
example: 1st MOndays, 2nd and 4th Tuesdays, etc. I then need to be able to
retrive those meetings by the corresponding calendar dates. (1st and 3rd
Wednesdays of April 2006 = April 5 and April 19.) Then I will be able to
merge with single occurance meetings, and sort in order by date and time.

Any suggestions?

I gave an NthXDay function in:

http://groups.google.com/group/comp.databases.ms-access/msg/3c3b63d850f03a05

The DateSerial function can be used to convert the day number into a
date or, alternatively, the NthXDay function can be changed to return a
date and be renamed as NthXDayDate.

James A. Fortune
(e-mail address removed)