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.