Access 2000 - Extracting DAY filed From Date

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

Guest

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
 
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])
 
fredg said:
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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top