display result from SQL Querry in txtbox

[Guest]

Can someone tell me how to display in the txtbox a result from SQL querry
querry returns just a single value:

SELECT sum(orPrice) from tbOrders

 

[Guest]

In the TextBox Control Source property you can use DlookUp

If this is the SQL
SELECT sum(orPrice) As SumOfPrice from tbOrders

Then
=DLookUp("SumOfPrice","QueryName")
============================
Or you can skip the Query, and write
=Dsum("orPrice","tbOrders")

 

[Guest]

thanks DSUM was what i was looking for

In the TextBox Control Source property you can use DlookUp

If this is the SQL
SELECT sum(orPrice) As SumOfPrice from tbOrders

Then
=DLookUp("SumOfPrice","QueryName")
============================
Or you can skip the Query, and write
=Dsum("orPrice","tbOrders")