Month excluding Years

[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

 

[Van T. Dinh]

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

Month()
MonthName()
DatePart()

 

[John W. Vinson]

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?

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]

 

[Biju George]

Thanks

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?

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]

 

[Biju George]

Thanks

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

Month()
MonthName()
DatePart()