Birth Date Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
George said:
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
Click to expand...

=Format(BirthDate, "mmmm")
 
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
 
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
Click to expand...

It goes in the RecordSource field

Tom Lake
 
If you're using the Format property of the textbox control, all you need to
put is "mmmm" (without the quotes)
 
Thanks - Doesn't work - This stops all other fields from working - report
build from Query.

Thanks - Still trying to resolve.



PC Datasheet said:
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


George said:
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
Click to expand...
Click to expand...
 
George said:
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
Click to expand...

It goes in the ControlSource of the TextBox.
 
Back
Top