data from not linked sources

[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

 

[Duane Hookom]

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

 

[Guest]

Thank you Duane, it worked!

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

--
Duane Hookom
MS Access MVP
--

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