Help with Report

[LisaK]

Oct 06 Nov 06
RwRsn C170 RC85 C170 RC85
BAIR 10 15 20 16
BRID 12 18 6 10


The above table is in an excel spreadsheet and I would like to do something
just like this in access. Should I do a crosstab query or do it in report?
Any suggestions would be greatly appreciated. I tried a crosstab query but
could not get it to work because I need 2 column headings, one for the date
and for the report name (ie. C170 & RC85). When I do a query it puts all the
data for the C170 report first and then puts the data for the RC85 last. I
would like the two side by side for ease of comparison.

thanks

 

[Duane Hookom]

You can derive multiple column values in a crosstab using the solution found
at http://www.tek-tips.com/faqs.cfm?fid=4524.

Since you are creating monthly intervals, you might also be interested in
dynamic monthly crosstab reports at http://www.tek-tips.com/faqs.cfm?fid=5466.

Let us know if you have any questions.