Query vs Dlookup

[Kavy]

Good day

I want to populate a textbox or combox which pulls data from my tables and calculates how much money I should have saved from a specific day. In order to do this it must a few variables, something easily done with the query design tool in Access 2007:

<code>
SELECT (Date()-[Start])*[$perDay] AS BTD, [Amount]/([end]-[start]) AS [$perDay], BAccounts.Amount, BAccounts.Open, BVendors.Vendor
FROM BVendors INNER JOIN BAccounts ON BVendors.ID = BAccounts.BVendor
WHERE (((BAccounts.Amount)>0) AND ((BAccounts.Open)=True));
</code>

My question is two part 1) how do I get the query field BTD to appear in a textbox (I tried to put the line below as the control source for the text box but it didn't work)

<code>
=[BTD Dollars]![BTD]
</code>

2) Is it more efficent to use Dlookup in a textbox instead of this query?

Thank you

Kavy

 

[apr pillai]

If the Query is used as Record Source to the Form, where the text box is, then you can use BTD directly on the Control Source property of the Text Box or use the expression as you have mentioned <code>=[BTD Dollars]![BTD]</code>. Otherwise you must use =Dlookup("BTD","QueryName") to bring the value into the Text Box.

 

[Kavy]

Thank you!