Access 2000 - Extracting DAY filed From Date

Hi,
I am trying to do a report in Access 2000 in which I need to extract the
DAY number out of a date field that is formatted mm/dd/yyyy. I only want the
DAY since I need to sort the records based on the DAY of the month.

Do I need to do this in a Querie or in the REPORT and if so, please
demonstrate HOW to do this.....
My Table name is Membership Table
My Date Field is named Birth Date

--
Thanks in advance for your help...

Larry H.

On Sat, 1 Oct 2005 20:22:01 -0700, Larry H wrote:

Hi,
I am trying to do a report in Access 2000 in which I need to extract the
DAY number out of a date field that is formatted mm/dd/yyyy. I only want the
DAY since I need to sort the records based on the DAY of the month.

Do I need to do this in a Querie or in the REPORT and if so, please
demonstrate HOW to do this.....
My Table name is Membership Table
My Date Field is named Birth Date

Here are several ways.
1) In the report, set the Format property of the [Birth Date] control
to:
dd

2) In the report, use an unbound control. set it's control source to:
=Format([Birth Date],"dd")

3) In the report:
=DatePart("d",[Birth Date])


--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

"fredg" wrote in message
...
On Sat, 1 Oct 2005 20:22:01 -0700, Larry H wrote:

Hi,
I am trying to do a report in Access 2000 in which I need to extract the
DAY number out of a date field that is formatted mm/dd/yyyy. I only want
the
DAY since I need to sort the records based on the DAY of the month.

Do I need to do this in a Querie or in the REPORT and if so, please
demonstrate HOW to do this.....
My Table name is Membership Table
My Date Field is named Birth Date

Here are several ways.
1) In the report, set the Format property of the [Birth Date] control
to:
dd

2) In the report, use an unbound control. set it's control source to:
=Format([Birth Date],"dd")

3) In the report:
=DatePart("d",[Birth Date])


4) In the report:

=Day([Birth Date])

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)