I have a field containing the birthdate of someone

H

Henro

How do I calculate that person's 'partyday's?

Tabel Engineer
[Engineer] Henro
[Birthday] 12-7-1974

Form Engineer
[Engineer] Henro
[Birthday] 12-7-1974


I have a table 'Agenda'
[Engineer] Henro
[Startdate] '366 records, one for each day in 2004
[Description]

Now I want the description field filled with 'Party' if that engineer is
having his birthday so that in the agenda I see:

Henro Veijer 12-07-2004 Party
 
A

Arvin Meyer

This may help:

http://www.datastrat.com/Download/Birthday2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Henro said:
How do I calculate that person's 'partyday's?

Tabel Engineer
[Engineer] Henro
[Birthday] 12-7-1974

Form Engineer
[Engineer] Henro
[Birthday] 12-7-1974


I have a table 'Agenda'
[Engineer] Henro
[Startdate] '366 records, one for each day in 2004
[Description]

Now I want the description field filled with 'Party' if that engineer is
having his birthday so that in the agenda I see:

Henro Veijer 12-07-2004 Party
Click to expand...
 
M

Mike Painter

Henro said:
How do I calculate that person's 'partyday's?

Tabel Engineer
[Engineer] Henro
[Birthday] 12-7-1974

Form Engineer
[Engineer] Henro
[Birthday] 12-7-1974


I have a table 'Agenda'
[Engineer] Henro
[Startdate] '366 records, one for each day in 2004
[Description]

Now I want the description field filled with 'Party' if that engineer is
having his birthday so that in the agenda I see:

Henro Veijer 12-07-2004 Party
Click to expand...

The easy way is to format the date "mm dd" (or "dd mm") and get "12 7", you
already know the year.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select next item in datareader, then insert a new record and update the rest 5
How do I create a field containing the word count of just one style? 2
History of Xbox 360 defects - Dean Takahashi has the inside story(long) 2
Can anyone tell me what other Backup products have any of the problems that I have encountered with 6
WTD: Nvidia Videocard for 4x AGP Slot 0
FWT Newsletter - Weekly - February 2, 2004 1
Understanding the Cell Microprocessor [VERY LONG] 12
FWT Newsletter - Weekly - September 6, 2004 1

Top