Report showing multiple queries

[Arugg]

I know I should be able to produce a report using multiple query fields from multiple tables. However, when I select the fields I want I get the following....

"You have chosen fields from record source which the wizard can not 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."

What am I doing wrong?

 

[lespaul]

From reading the error, I would guess that you are selecting fields from TABLE_A and one of the queries that you are selecting fields from also selects from TABLE_A.

You are being instructed to only select fields from the original TABLE_A or the query that contains the fields from TABLE_A.

Go back, review the queries and see which one is selecting from TABLE_A, add the additional fields you want from TABLE_A to that query and don't use TABLE_A in your report query.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[Arugg]

Les,

Thanx. But I am using fields from 2 queries that pull from the same table. Each query does some calculations for various xls sheets. I am trying to find a way to produce the report in Access versus using excel.

 

[KenReay]

May be you need to use a report containing two sub reports (ie one based on each query)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[razchip]

You may be able to add a third query that combines the two queries that currently contain the data you need.

Thanks for the help.
Greg