Group in Columns

  • Thread starter Thread starter LanWanMan
  • Start date Start date
L

LanWanMan

Hello,

I have a database of equipment transactions. Each transaction has hours
used and date used for each piece of equipment. Each piece of equipment is
categorized by type. I have the transactions grouped by category equipment
number successfully not showing detail just totals, but I need an additional
grouping in columns across the page for each month.

My result should read:

2005-01 2005-02 2005-03 2005-04
2005-05 2005-06 2005-07 2005-08 2005-09 2005-10 2005-11
2005-12

Category

Equipment1 HRS HRS HRS HRS
HRS HRS HRS HRS HRS HRS
HRS HRS
Equipment2 HRS HRS HRS HRS
HRS HRS HRS HRS HRS HRS
HRS HRS

Any help would be appreciated. Please reply to the newsgroup.

Thanks,

Michael
 
PS...the formatting probably does not look right, but I think you get my
meaning.

Thanks
 
Jeff,

Thanks....I knew there was something I was missing, however, with my limited
experience with the crosstab query, I wasn't able to get it to do what I
need. Perhpas you can help.

I have a table filled with transactions for pieces of equipment. Each peice
of equipment has multiple transactions in a month. Each row has a category,
equipment number, transaction date truncated to be yyyymm, & transaction
hours. I need the report to group the category, then list the total hours
for each piece of equipment in columns: 200501, 200502, 200503, etc. I do
not need the transaction details, just the total for that month in the
correct column. Is this something you think I might be able to do.

Thanks,

Michael
 
Yes. Check Access HELP for crosstab queries and crosstab reports. Remember
that any sorting you do in the query does NOT show up in the report --
you'll have to use Grouping/Sorting in the report to achieve what you're
after.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top