Monthly Crosstab Report

[Raul Sousa]

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.

 

[Duane Hookom]

There is a solution for this at http://www.tek-tips.com/faqs.cfm?fid=5466.