Dates as quarters

[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?

 

[Duane Hookom]

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

 

[acss]

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

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

--
Duane Hookom
Microsoft Access MVP

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?

 

[Duane Hookom]

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

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

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

--
Duane Hookom
Microsoft Access MVP

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?

 

[Gitche Gumee]

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.