If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create a report by birthmonth
I am trying to find out how to sort standard birthday data (mm/dd/yyyy) by month and day and then create a report. Ideally I would like to choose which month to create the report for. By default Access will sort birthdays in order, earliest years first. I am a newbie to programming so if I need to use VB in Access please be detailed or point me to the proper reference as the Knowledge Base articles that I have come up with assume very good programming skills.
Thanks, Brian |
#2
|
|||
|
|||
Create a report by birthmonth
Just set the sort to:
=month([BirthDate]) Hope this helps. Fons -----Original Message----- I am trying to find out how to sort standard birthday data (mm/dd/yyyy) by month and day and then create a report. Ideally I would like to choose which month to create the report for. By default Access will sort birthdays in order, earliest years first. I am a newbie to programming so if I need to use VB in Access please be detailed or point me to the proper reference as the Knowledge Base articles that I have come up with assume very good programming skills. Thanks, Brian . |
Thread Tools | |
Display Modes | |
|
|