Birth Date Field

[Guest]

On my personnel data report I want to include their birth date, but I only
want to show their birth Month - don't want to embarass anyone. I have the
field working - how do I get block the date and year and display just the
month ?

Thanks - George

 

[Rick Brandt]

On my personnel data report I want to include their birth date, but I
only want to show their birth Month - don't want to embarass anyone.
I have the field working - how do I get block the date and year and
display just the month ?

Thanks - George

=Format(BirthDate, "mmmm")

 

[PC Datasheet]

In the recordsource for your report use BirthMonth:Month([BirthDate])

 

[Guest]

I loaded the statement you gave me first in the input mask field - didn't
work - then tried it in the Format field - Doesn't work ? What am I doing
wrong ? Thanks

 

[Tom Lake]

I loaded the statement you gave me first in the input mask field - didn't

work - then tried it in the Format field - Doesn't work ? What am I doing
wrong ? Thanks

It goes in the RecordSource field

Tom Lake

 

[Douglas J. Steele]

If you're using the Format property of the textbox control, all you need to
put is "mmmm" (without the quotes)

 

[Guest]

Thanks - Doesn't work - This stops all other fields from working - report
build from Query.

Thanks - Still trying to resolve.

In the recordsource for your report use BirthMonth:Month([BirthDate])

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

On my personnel data report I want to include their birth date, but I only
want to show their birth Month - don't want to embarass anyone. I have the
field working - how do I get block the date and year and display just the
month ?

Thanks - George

 

[Guest]

Thanks - This worked mmmm in the format field

George

 

[Rick Brandt]

I loaded the statement you gave me first in the input mask field -
didn't work - then tried it in the Format field - Doesn't work ?
What am I doing wrong ? Thanks

It goes in the ControlSource of the TextBox.