John,
Thank you as always for your help.
I was not aware that the Report Wizard has limitations. That might explain
a portion of my problem. Interesting.
I'll do a search and see if having subreports increases the number of fields
beyond 255.
Thanks again.

"John Spencer (MVP)" wrote:

A report can only be based on a single query.
A report can contain sub-reports.
A query can contain up to 255 columns (fields, calculated fields) and therefore
a report can have a maximum of 255 fields.

Are you using the report wizard to build your report? If so, it has a much
lower limit than if you design the report yourself. I don't know what the limit is.

PZ Straube wrote:

Destin,
Thanks for taking the time to respond.
As I mentioned to Duane, I screwed up - I didn't think this through
carefully. I have now put another query on top of the one that was
previously feeding data to my reports and in this new query, I only included
the fields needed for the reports, not some of the supporting fields contain
preliminary calculations, and that gives me room to add the fields I couldn't
before - whcih is what led em to think I needed a second query to feed the
report.
Sorry to have bothered everyone with this rookie mistake.

If you don't mind me asking, what happens when you have a report containing
more than the maximum number of fields? What is the key point when using two
queries to feed a report to make sure it works?
Thanks again.

"Destin Richter" wrote:

PZ, it just sounds like bad query design. Why can't the report be based on a
single query? If the database is small, tell me what your goal is and send
over a copy stripped of the most of the data.

Destin Richter


"PZ Straube" wrote:

Hello,

For a report I have in Access 2003, I have apparently tried to have too many
fields in the single query that feeds it data and received error message 3190
when running this query. I took the new data fields I tried to add to the
original query and put them in a second query. Because I'm a novice and
haven't had two sources of data for a single report, I went to the Report
Wizard to play around with this before modifying my existing report. In the
Report Wizard, I see that when I get to the point of selecting fields, I can
change the query or table to be used, thus allowing for multiple sources of
data. However, when I tried to have data from more than one source, I
received the following message:

"You have chosen fields from record sources which the wizard can't connect.
You may have choosen fields from a table and from a query based on that
table. If so, try choosing fields from only the table or only the query."

Here's where I'm at. I am trying to get data from two queries:
Filter_3_part_1 and Filter_3_part_2. Both rely on data from the same query,
Filter_2 (which, via Query Filter_1, uses data from the a single table called
Main_Data). Both of the Filter_3 queries have the same primary key field
from table Main_Data.

I need to figure out what I am doing wrong so I can use data from these two
queries in my report but I don't know where to start.

Thanks to anyone can point me in the right direction.