Short Date to Text Value

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

I have a financial report based on payments received.

It has a [Date] field which is in short date format.
and a [Payment] field.

I want to sort the payments into months.

Example: all the payments that fall between 1/1/2003 and
1/31/2003 will return the value "January 2003" as a date
value, etc..

What is the best way to do this? And would the solution
be in the query or the report?

Thanks for any help in advance.
 
To display the payments broken down by month, use a report.

1. With the report in design view, open the Sorting and Grouping dialog
(View menu).

2. Enter the name of your date field.

3. In the lower pane of the dialog, set Yes for Group Header and for Group
Footer, and specify an Interval of Month. (Access adds date header and
footer sections to your report.)

4. In the new date header section, add a text box bound to the date field.
Set the Format property of this box to:
mmmm yyyy

5. In the date footer section, add a text box, and set these properties:
Control Source: =Sum([Payment])
Format: Currency

The text box at step 4 shows the heading over each month.
The text box from step 5 shows the total for each month.

(If you wanted to suppress the details, you could set the Visible property
of the Detail section to No.)
 
Back
Top