Monthly Crosstab Report
- From: Raul Sousa <RaulSousa@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 16 Sep 2008 08:53:01 -0700
I have a query with several fields: Date, Value, type, group and category.
I need to present this data in a report where which month is a column.
Something like:
Jan Feb Mar Apr Mai …
Type A
Type B
Type D
Type E
…
Any idea on how can I approach this?
My problem is to split one field, in this case the value field, in 12 fields.
.
- Follow-Ups:
- RE: Monthly Crosstab Report
- From: Duane Hookom
- RE: Monthly Crosstab Report
- Prev by Date: Re: Automatically populate fields in send object
- Next by Date: Access Report to Publisher - Best Quality (Universal Document Conv
- Previous by thread: Report in Access97
- Next by thread: RE: Monthly Crosstab Report
- Index(es):