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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to create a report based on multiple queries 3
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Weekly Report 2
QBF & Query Malfunction 0
Help buidling data input form, please? 6
Report Query Works 2nd Time, But Not 1st 14
Add a table 11

Top