Multiple Column Report

[xicana]

Hello,

I'm using WinXP and Access 2003.

I have report that is getting data from a query which has somthing like this:

JobNo ContractAmt AmtBilled Month
AAA 1000.00 500.00 May
AAA 1000.00 750.00 June
BBB 2000.00 300.00 May
BBB 2000.00 800.00 June

I want to create a report that displays the data by month, side-by-side, ex:
MAY June
JobNo ContractAmt AmtBilled JobNo ContractAmt AmtBilled
AAA 1000.00 500.00 AAA 1000.00 750.00
BBB 2000.00 300.00 BBB 2000.00 800.00

*of course the headings would be lined up* =)

-Grouping on report:
Month (shows header and footer)

I have tried going into the page setup and changing the number of columns to 2, and changing the "New Row or Col" property of the month group footer to "after section", and I get the months dipslayed side to side, but the data in the detail section for the second month does not line up with the data from the first month.

This report is for straight comparing between 2 months for each Job - I need my client to be able to go across a row and have the info for two months for a specific job in that row.

Is there a better way to do this?
Thanks,
Sandy

Sandy

 

[xicana]

NEVER MIND...

All I needed to do was a sorting with JobNo...very simple - I got up too early this morning.

different question...

how can I get the page header to CENTER on a page that has 2 columns?

Sandy

 

[xicana]

One more question:

Can I get a field in the detail section to only show up on the first column of a two column report?



Sandy