query

  • Thread starter Thread starter antonov
  • Start date Start date
A

antonov

Is it possible to have a query divide the data per month and per code to get
a yearly overview? I need the results to be in both a chart (I know how to
do that) and a report
thanks
 
you can use a Totals query to group the data by code within each month, or
by month within each code. or you can do that directly in a report, using
the Sorting and Grouping options. you might also try a Crosstab query, to
see if that gives you the results you're after.

hth
 
grouping does just what it says, whether at the query level or the report
level: it groups records by the available values in a specified field, then
by the available values in the next specified field, then the next, etc. so
if you group by month, then code, your query or report would shows the
records for the first month, and grouped within that month by code, then
records for the next month, grouped again by code, etc. if you group by
code, then month, you'll get the records for the first code, then within
that code by month, then the next code, again grouped by month, etc.

look up "Total records in a query (MDB)" in Access Help for some more detail
on the mechanics of creating a Totals query. keep in mind that the Help
topic explains how to calculate totals of the records (Sum, Count, Average,
etc), but you don't have to do anything but group the records if you don't
want to.

to do the grouping at the report level, create a new report using the Report
Wizard. the wizard will walk you through the process, including asking of
you want to group the records. doing this will give you a basic setup to
familiarize you with a "grouped" report. in report design view, click View |
Sorting and Grouping from the menu bar, and study the settings in the
Sorting and Grouping box. also look up "Examples of grouped reports" or just
"report grouping" in Help.

hth
 
Back
Top