trouble referrencing data in query.

  • Thread starter Thread starter Jason S.
  • Start date Start date
J

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
 
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
 
Jason said:
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?
Click to expand...


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.
 
Back
Top