data from not linked sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I create the report it is based on a table or querry.
What shall I do if I need to display some calculation results that come from
another querry? I tried just to specify in the control source of a TextBox1
the name of the querry and the field from it which I need to be displayed:

=[Query_Name]![EXPR]

But it doesn't work. :(

If I put it into a sub-report, how then I can refer to that Text Box value
when I need to calculate the difference:

=((Reports![ReportName].Child1.[TextBox1])-(Sum([Amount in VND])))

????

Please help!!!! I am all lost! :(
Thank you.
Lana
 
Thank you Duane, it worked!

Duane Hookom said:
Use:
=DLookup("[yourfield]","[YourTableQuery]")

--
Duane Hookom
MS Access MVP
--

Lana said:
When I create the report it is based on a table or querry.
What shall I do if I need to display some calculation results that come from
another querry? I tried just to specify in the control source of a TextBox1
the name of the querry and the field from it which I need to be displayed:

=[Query_Name]![EXPR]

But it doesn't work. :(

If I put it into a sub-report, how then I can refer to that Text Box value
when I need to calculate the difference:

=((Reports![ReportName].Child1.[TextBox1])-(Sum([Amount in VND])))

????

Please help!!!! I am all lost! :(
Thank you.
Lana
Click to expand...
Click to expand...
 
Back
Top