Strange error when building report.

[dmschulz]

I am building a report using a query and the report wizard. Every time I get
to the end I get the error that I have selected too many fields and must
start over and select fewer fields. I have already built one report with
similar information in this same database and just need to build this last
one. I have never gotten an error like this before and I have built bigger
reports than this. What's different now? Anybody know how to fix this? Any
help is appreciated. Thanks, Dawn.

 

[Gina Whipp]

dmschulz,

Could be the fields are exceeding the reports limit of 22 inches? OR it
just be too many fields... How many fields are in the query?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[dmschulz]

Gina, There are 45 fields in the report. I have already built one with the
exact same fields and I just need to do it again for a different set of
criteria. I rebuilt the query and now need to build the report. Any help you
can offer is appreciated. Thanks, Dawn

 

[Gina Whipp]

Okay, let's try this copy the report and change the RecordSource of the
copied report to your new query. What happens?

I also am curious why you just can't change the criteria of the present
report and just use the same report? Are you using a button to print the
report?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[dmschulz]

Gina, Thanks. I copied the report and changed the record source and it works
great.
If I were going to be using the database, I would have done as you suggested
and just changed the criteria as needed. But unfortunately, I am building for
another user and she needs something very user friendly. Which translates...
separate reports. Thanks again for your help. Dawn

 

[Gina Whipp]

Dawn,

Glad to help... just a long as it works.

My two cents worth... You could build a menu with a combo box with the
Criteria list and allow the User to make predefined selections from the list
and then click a button to run the report.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm