Help with reports using many fields (>100)

[roland_access]

I have a table containing month fields from Jan01 to Dec09 (thats 108 fields btw). The data within these fields is a monetary amount, if it matters. There is only ever 6 records in this table.

What I need to do is make a report based on the table that reads ACROSS, not down. I cannot do this at present because the maximum width is set to 55ish (A4 sheet) and the minimum width of the text box for each field means i can only fit about 2.5 year's worth on the report.

Can anyone help please?

 

[Sohaila Taravati]

Use crosstab query

 

[Rich]

You have a design problem, you only need one field in a table to record the Date/Month