Query for a Quartely Report

[Guest]

Hello:

I checked help, the Internet, and this forum, but couldn't find an answer to
my question. We have a table that lists thousands of records for the year
2006. I want to build a query for a report grouped by quarters for the year
2006, using the [Date_Filed] field. I tried the following in my query for the
Date_Filed field, however, Access rejected it as an error.

Format([Date_Filed],"yyyyq")

Can someone please advise how I can easily and quickly run a query that
breaks down our 2006 records into quarters using [Date_Filed]?

Thanks,
Robert

 

[John Spencer]

What was the error message?

Is Date_Filed a datetime field? If it is a text field, then that may be the
cause of the problem.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Hello John:

Date_Filed is a Date_Time field.

I found another way to solve the problem that was very easy. Instead of
building the quarterly report in the query, I designed the report, grouped on
[Date_Filed] and selected "Quarterly" as the interval option.

Thanks,
Robert

What was the error message?

Is Date_Filed a datetime field? If it is a text field, then that may be the
cause of the problem.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Hello:

I checked help, the Internet, and this forum, but couldn't find an answer
to
my question. We have a table that lists thousands of records for the year
2006. I want to build a query for a report grouped by quarters for the
year
2006, using the [Date_Filed] field. I tried the following in my query for
the
Date_Filed field, however, Access rejected it as an error.

Format([Date_Filed],"yyyyq")

Can someone please advise how I can easily and quickly run a query that
breaks down our 2006 records into quarters using [Date_Filed]?

Thanks,
Robert