Report -- too many fields

[Guest]

I have a table called Purchase in which three rows together repesent data for
a specific customer for 3 consecutive months. I'm trying to create a report
that displays my data in a tabular report because this is how my boss wants
to see the information. I also have to add some of these together and
calculate daily averages, etc. The problem that I'm having when creating the
report is that it says that I'm choosing to many fields!!! Also, I need to
report information form other tables as well, like three different fields
form other tables in the page header. Therefore I was wondering if there is a
way I can set up a query or something prior to the report that will let me
shows these rows in a column form.

Thanks.

 

[Rick B]

Yes, you can build a query and then base your report off of that.

Or, you can simply build your report, then go into the properties and change
the data source. If you click on the elips (...) it will open a window just
like the query design screen and you can add additional tables.

As far as too many fields, I would guess you are getting this error trying
to use the wizard? Just build the report with a few fields so the wizard
will run, then go in and add additional fields while in design view.
Personally, I don't use the wizards for reports. They rarely look like I
want and it is just as easy to do it from scratch (in my opinion).

Rick B

 

[Guest]

If I already tried doing the report/form from scratch but it is still
telling me that I have more than 255 fields selected, which I don't (I have
199), is there anything I can do? (When reffering to scratch, I mean going
into the record source and adding the tables I want to display and then
selecting the fields and/or building formulas to display)

Thanks.

 

[Rick B]

The maximum is number of CONTROLS added over the life of a report. That
includes headings and such.

Also, if you add a field, then delete it, it counts!

255 is a BUNCH of fields.

I'd recommend breaking this down into smaller subreports for the details and
place those subreports into a larger master report containing your overall
data and sorts.

Rick B