Dates of Birth

  • Thread starter Thread starter Mike Hosford
  • Start date Start date
M

Mike Hosford

Hi
Dates of birth are in date/time format- need instructions
on how to select birthdays by specific month so that I
can send greetings to my Clients from all years not just
one year ie: everybodys birth date that falls in November
from say 1940 - 2003.

any help would be much appreciated

nb what is an operator and what is an operand

sorry to be a dumbo

Cheers Mike
 
You need to use a criteria in the Query that chooses just
those with a month value of 1 through 12.

SELECT Customer.Customer, Customer.BirthDate, etc.
FROM Customer
WHERE ((Month([Customer]![BirthDate])=[?]));

And then when prompted, enter the month value (1=January,
2=February, etc)

In my opinion, an OPERATOR and an OPERAND are kinda the
same thing.
 
Hi
Dates of birth are in date/time format- need instructions
on how to select birthdays by specific month so that I
can send greetings to my Clients from all years not just
one year ie: everybodys birth date that falls in November
from say 1940 - 2003.
Click to expand...

One way to do this is to use the DateSerial function to calculate this
year's birthday anniversary from the date of birth field (which I'll
assume is named DOB):

HappyHappy: DateSerial(Year(Date()), Month([DOB]), Day([DOB])

This combines the current year - Year(Date()) - with the month and day
of the birthdate.

You can then use a criterion on this field such as

BETWEEN Date() AND Date() + 7

to see those birthdays coming up in the next week.

Angela's suggestion for finding a specific month is fine too if that's
what you want to do - the HappyHappy field gives you some more
flexibility.
any help would be much appreciated

nb what is an operator and what is an operand
Click to expand...

An "operator" is a text string that tells a program to do something.
For instance, the plus sign + is an Operator that tells Access that
you want to add two things.

An "operand" is something acted upon by an operator. For example in
the expression

2 + 3

the operator is "+", and the operands are 2 and 3.
 
Back
Top