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?!