Query result as the value of a textbox 1

[jckokko]

On a report, I have a textbox. I would like the textbox's data source be a query result.
For example, the query statement is "select sum(amount) from ExpenseTable".
What's the work around?

 

[LonnieJohnson]

Set the Control Source of the text box to...

"select sum(amount) from ExpenseTable".

=DSum("amount","ExpenseTable&quot

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[LonnieJohnson]

Sorry I didn't mean to include your original line.

It should just be...


=DSum("amount","ExpenseTable&quot

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[jckokko]

Is DSum(..) the only solution? I thought Dsum() func is not efficient (probably I am wrong about this).

Thank God for your help

 

[jckokko]

Sorry for lack of explanation on the problem.
I have a select criteria:
select sum(amnt) from ExpenseTable where expenseType = "Auto" and anotherCriteria = "somethingElse".

 

[jckokko]

Oops never mind!
I was too lazy to look up the usage of the DSum func.
I am alright now. Thanks.