Month excluding Years

  • Thread starter Thread starter Biju George
  • Start date Start date
B

Biju George

I have a table of students birthday from 1978 till 2003 and want to know
which all students have birthdays in Jan, Feb, March, April,.. .. etc.
I have created a report but it shows each year and then the months, I want
only the months no year. Form or Report which will be better for this?

Thanks in advance.

biju
Kuwait
 
You can extract the month from the D.O.B. using VBA functions. Check Access
VB Help on the following functions:

Month()
MonthName()
DatePart()
 
I have a table of students birthday from 1978 till 2003 and want to know
which all students have birthdays in Jan, Feb, March, April,.. .. etc.
I have created a report but it shows each year and then the months, I want
only the months no year. Form or Report which will be better for this?
Click to expand...

To see it onscreen use a Form; to print it out use a Report.

You can sort the birthday anniversaries during the current year,
chronolgically, by putting a calculated field in the Query:

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

where DOB is the Date Of Birth field. Sort by this field in the Query,
or in the Report's Sorting and Grouping dialog.

John W. Vinson [MVP]
 
Thanks
John W. Vinson said:
I have a table of students birthday from 1978 till 2003 and want to know
which all students have birthdays in Jan, Feb, March, April,.. .. etc.
I have created a report but it shows each year and then the months, I want
only the months no year. Form or Report which will be better for this?
Click to expand...

To see it onscreen use a Form; to print it out use a Report.

You can sort the birthday anniversaries during the current year,
chronolgically, by putting a calculated field in the Query:

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

where DOB is the Date Of Birth field. Sort by this field in the Query,
or in the Report's Sorting and Grouping dialog.

John W. Vinson [MVP]
Click to expand...
 
Thanks
Van T. Dinh said:
You can extract the month from the D.O.B. using VBA functions. Check Access
VB Help on the following functions:

Month()
MonthName()
DatePart()
Click to expand...
 
Back
Top