trouble referrencing data in query.

[Jason S.]

I'm having difficulty reporting data from my multiple
queries. I have several queries that summarize data in my
database. When I write in my report, I have several text
boxes that que up this data to report it. When I make a
text box, I go to properties, and then to the control
source. On the control source line, I click the "." line
to get to the expression builder. I find the query and
select the value of the query I want. I've done this with
9 different queries. However, when I run the report, only
two of the text boxes report accurate data. The others
show "name?". I cannot tell what I am doing different
between the boxes that work and the ones that do not. Can
anybody tell what is going on here?
Jason

 

[Jason S.]

This is intresting. Ok to add to the confusion I
previously was having difficulties and made seperate
reports for each sumerized data. I then made subreports
inside the main report to show the data. This was very
messy and I do not like it. So, Ive been exploring new
ways to report my queries. So in my previous posting I
said that two of these text boxes showed data even though
I did the same process for each one. Well, when I delete
the subreports on the page, none of the text boxes show
data. How, even though I used the expression builder to
have the control source be tied to the query, can it be
tied to a seperate report? I am lost and thinking of
scrapping the whole thing.

Maybe instead of helping me with this mess... Is there a
good way to report seperate querries in a single report?
Jason

 

[Marshall Barton]

This is intresting. Ok to add to the confusion I
previously was having difficulties and made seperate
reports for each sumerized data. I then made subreports
inside the main report to show the data. This was very
messy and I do not like it. So, Ive been exploring new
ways to report my queries. So in my previous posting I
said that two of these text boxes showed data even though
I did the same process for each one. Well, when I delete
the subreports on the page, none of the text boxes show
data. How, even though I used the expression builder to
have the control source be tied to the query, can it be
tied to a seperate report? I am lost and thinking of
scrapping the whole thing.

Maybe instead of helping me with this mess... Is there a
good way to report seperate querries in a single report?

A report can only refer to a single query.

A text box can not refer to a query at all, only to fields
in the report's record source query.

The typical way to present data from multiple independent
queries is to use a subreport for each query.

You say this is "messy", but in most cases it's pretty
straight forward so I can't guess at what issue you're
trying to deal with.