access query with 12 columns

  • Thread starter Thread starter tonyrulesyall
  • Start date Start date
T

tonyrulesyall

I am using a Microsoft Access XP crosstab pivot query to get totals
across several
months.

I would like to show the first twelve months and number of files in
each month, then have a total on the right,
the next set of rows will have the next twelve months and number of
files in each month, a total on the
right,
the last row will show if I have any remainder months left.

If you have any ideas, please post.
 
Create a query based on the Xtab that adds the last column.
=Jan+Feb+Mar + ... + Dec

I don't understand the 'show if I have any remainder months left' concept
 
MORE information on your data structure. OR at least post the SQL of the
crosstab query. Hint: View: SQL from the design view of the query.

What is different between the rows that are returned? Are they different
years or different systems or ????

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