Multiple control sources

[Guest]

I have a report that has a table for a control source. The majority of the
data for my report is located in this table. For my report, I also need some
data located that is located in a query that I have made. I am hoping that I
do not have to change my record source to this query, as I have so much data
in the table and the report has has been developed using my table as a
control source. Is it possible to imbed a record within a record that would
have a different control source than my main record, ie (query rather than
table). Also I can't understand why Access would list the query in the
expression builder, and then when I write an expression that requires this
field, I get the "enter parameter value" error???? Please help and explain...

 

[Duane Hookom]

A report can have only one "record source" (control sources are for controls
on your report). If your table and query are related by field values
contained in the table and query, you should be able to set your record
source to a query or SQL statement that contains both the table and query.

 

[Guest]

I have a situation where the dataset has multiple details and one record that
is a "summary" record. I broke out the dataset into two queries, detail
records and the one summary record. Since reading this post and getting the
same error, I realize the two queries in one report won't work.

What I want to do is only reference the one summary record in the report
footer. How do I exclude it from the detail lines and only include the one
record in the footer?

Donnie

 

[Guest]

I have a situation where my dataset has multiple detail records and one
"summary" record. I split the dataset using queries and tried to pull the
two queries into a report and got the same error and reported here.

Here's what I am trying to do. I want to exclude the summary record from
the detail lines of the report and only reference the summary record in the
footer. This "summary" record is not the totals of the details. It contains
unique information. Can this be done?

Donnie

 

[Duane Hookom]

Without understanding completely, I would consider create a main report
based on the summary query and a subreport based on your details. You could
then total your summary information quite easily without interference from
the details.