printing data from more queries in 1 report

  • Thread starter Thread starter zaskodnik
  • Start date Start date
Z

zaskodnik

Hi All,

I have a report that prints data from query called "this mont
revenue". I want to add one unbound control that will show one numbe
that is in the query "upside total". The query "upside total" has onl
one number, and I want this number to be shown at the bottom of th
report that uses query "this month number".

I created unbound control, clicked on properties -> data -> contro
source, then on those 3 dots... then "expression builder" opened...
and I chose the query and value like this: "[CURRENT upside total]![Su
Of ExtPrice]"
Then I clicked OK and closed the Expression Builder. When I want t
switch to report view it is asking "enter parameter value" and when
enter some number.... it shows report and instead of the field wit
number, it says "error##".

Any suggestions?
Thanks
 
zaskodnik said:
I have a report that prints data from query called "this month
revenue". I want to add one unbound control that will show one number
that is in the query "upside total". The query "upside total" has only
one number, and I want this number to be shown at the bottom of the
report that uses query "this month number".

I created unbound control, clicked on properties -> data -> control
source, then on those 3 dots... then "expression builder" opened....
and I chose the query and value like this: "[CURRENT upside total]![Sum
Of ExtPrice]"
Then I clicked OK and closed the Expression Builder. When I want to
switch to report view it is asking "enter parameter value" and when I
enter some number.... it shows report and instead of the field with
number, it says "error##".
Click to expand...


A Control Source can not refer to a query (only Record
Source and Row Source). Maybe you can use the DLookup
function to get the value by setting the text box's control
source to an expression like:

=DLookup("[Sum Of ExtPrice]", "CURRENT upside total")
 
Back
Top