Dates as quarters

  • Thread starter Thread starter acss
  • Start date Start date
A

acss

I have an invoicing DB that contains entry dates of each day of the month.
How do i group these dates so the report shows them in quarters?
 
If your quarters are Jan-Mar, Api-Jun, .... then you can use
DatePart("Q",[DateField])
 
Sorry Duane. I typically use the wizard from a select query so where would i
use your answer?

Duane Hookom said:
If your quarters are Jan-Mar, Api-Jun, .... then you can use
DatePart("Q",[DateField])

--
Duane Hookom
Microsoft Access MVP


acss said:
I have an invoicing DB that contains entry dates of each day of the month.
How do i group these dates so the report shows them in quarters?
Click to expand...
Click to expand...
 
You could create a new calculated column in your query. Set the field to
something like:
TheQtr: DatePart("Q",[Date Field])

You could also set the control source of a text box in a report to
=DatePart("Q",[Date Field])

You would need to make sure the name of the text box is not the name of a
field.

--
Duane Hookom
Microsoft Access MVP


acss said:
Sorry Duane. I typically use the wizard from a select query so where would i
use your answer?

Duane Hookom said:
If your quarters are Jan-Mar, Api-Jun, .... then you can use
DatePart("Q",[DateField])

--
Duane Hookom
Microsoft Access MVP


acss said:
I have an invoicing DB that contains entry dates of each day of the month.
How do i group these dates so the report shows them in quarters?
Click to expand...
Click to expand...
Click to expand...
 
In your report, add a header for the entry date. In Sorting and Grouping for
your report, set the entry date header to Group On Qtr.
 
Back
Top