Report Wizard Field Limit

[russi]

Don't laugh but I am using Access 97.
I was hoping to use the Report Wizard to layout the report from a query. I only have a 1 field group by. But get an error message that says I have too many fields for Report Wizard.
Do you know what the limit is? I read that for a manually laid out report the limit is 750+ fields/ controls/...
This query has approx. 40 fields.

Russ

 

[boblarson]

I think the report wizard can only handle something like 24 fields when you use it. So you will have to build the report by hand.

The steps:

1. Create a blank report

2. Add the RecordSource to it by going to the report's Record Source property in the dialog for properties and select the table or query to use.

3. The Available Fields can be looked at by selecting VIEW > FIELD LIST (in Access 2003 or prior) or the ADD EXISTING FIELDS button (in 2007 and above). You can drag and drop onto your report as a starter, all of the fields. Then you will have to modify the controls to fit the way you want. If using 2007 or above you may need to do this to keep the controls from moving together.

4. You can then go add your group and whether to use a header/footer or both.

See what you can do and then we'll go from there.

 

[russi]

Thanks for the response, Bob.
I have done reports the manual way. I guess I was hoping to 'be lazy' especially where this report does not need to look good. Only be practical.

Anyway, thanks, again, Bob.

Russ