Date Format

[Guest]

I have a report made from a query which reflects the employees that have a
birthday in a particular month. For instance, any employee that has a
birthday in April will be on the report if the number 4 is placed in the
parameter box. I have the capability of placing the full birthdate on the
report but have been told that this is not what my client wants. He would
like the date to reflect only the day and month. How would I format their
birthday to show this information?

Thanks for any help.

 

[Rick Brandt]

I have a report made from a query which reflects the employees that
have a birthday in a particular month. For instance, any employee
that has a birthday in April will be on the report if the number 4 is
placed in the parameter box. I have the capability of placing the
full birthdate on the report but have been told that this is not what
my client wants. He would like the date to reflect only the day and
month. How would I format their birthday to show this information?

Thanks for any help.

Ue a format property of "mmmm d" or "mmm d" or "d/mm" depending on what you
want.

 

[John Vinson]

I have a report made from a query which reflects the employees that have a
birthday in a particular month. For instance, any employee that has a
birthday in April will be on the report if the number 4 is placed in the
parameter box. I have the capability of placing the full birthdate on the
report but have been told that this is not what my client wants. He would
like the date to reflect only the day and month. How would I format their
birthday to show this information?

Thanks for any help.

"dd/mm" for 12/04; "mmm dd" for Apr 12; "mmmm dd" for April 12.

John W. Vinson[MVP]

 

[Tony Toews]

I have a report made from a query which reflects the employees that have a
birthday in a particular month. For instance, any employee that has a
birthday in April will be on the report if the number 4 is placed in the
parameter box. I have the capability of placing the full birthdate on the
report but have been told that this is not what my client wants. He would
like the date to reflect only the day and month. How would I format their
birthday to show this information?

Do ensure that that database is kept quite secure. Any database with
an employee name and birth date could be used for identity theft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm