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?!
--
Many thanks
Lesley

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?

"Lesley" <(E-Mail Removed)> wrote in message
news:45E077F4-C9E8-486A-96E3-(E-Mail Removed)...
> 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?!
> --
> Many thanks
> Lesley