Access 2000 report problem

L

Lesley

Hi

I have attempted to creat a report using fields from 6 different sum queries.

Using report wizard I am able to create a report easily with fields from
only one of the queries. When i try to add all the fields I want from the
queries i get the error message -

"You have chosen fields from record sources which the wizard can't connect.
You may have chosen 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."

I am definately only choosing fields from queries!!!!!!

Can someone please solve this one for me?!
 
B

BruceM

You will need to find a way to join the queries together. You can only
select on of the queries as the record source. What is the connection
between the data from the 6 queries? That is, in what way are they all part
of the same record?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a report based on multiple queries 3
Help buidling data input form, please? 6
Add a table 11
queries on report 4
creating query- 'record sources which the wizard can't connect' 2
report and drop down list? 4
create a report based on 30 queries 8
Too Many Fields Defined Error 1

Top