Birthday form

[alpapak via AccessMonster.com]

Birthday form
------------------------------------------------------------------------------
--

hi
i want to make a birthday form and to display me name , age , day of birth .
i need to see the birthdays of the following 30 days.??.

table Customers
CustomersID
NameCustomers
DayOfBirth


From this table i will make a form

thxs

 

[alpapak via AccessMonster.com]

help pls

 

[Duncan Bachen]

Birthday form
------------------------------------------------------------------------------
--

hi
i want to make a birthday form and to display me name , age , day of birth .
i need to see the birthdays of the following 30 days.??.

table Customers
CustomersID
NameCustomers
DayOfBirth


From this table i will make a form

thxs

Same process as the last two messages. The function you need to use is
dateadd().

Your criteria to find birthdays in the next 30 days is:
Between Date() and DateAdd("d", 30, Date())

 

[fahre]

Make this query:

SELECT Customers.NameCustomers, Customers.DayOfBirth
FROM Customers
WHERE (((Month(Customers!DayOfBirth))=Month(Now())) AND
((Day(Customers!DayOfBirth))>=Day(Now()))) OR
(((Month(Customers!DayOfBirth))=Month(Now())+1) AND
((Day(Customers!DayOfBirth))<Day(Now())))
ORDER BY Month(Customers!DayOfBirth), Day(Customers!DayOfBirth);

This query must be source for your birthday form