Total line from a Query displayed in a form

grogmi1

Registered User.
Local time
Today, 06:20
Joined
Oct 26, 2012
Messages
56
Hi,

I am looking for some help with displaying the totals from a query onto a form.

I have a query which has a total line showing a count of the number of entry's in each column. I would like to be able to display these totals on one of my forms in text boxes (or any other way). Is this possible and if so how do I do it ?

Thanks in advance !
 
Hello,

Use the DLookUp function as the source of the TextBox
Code:
=DlookUp("[ControlOfTheQuery]","[TheQuery]")

Good continuation
 
Hi,

Thanks for your reply

I'm not sure what you mean by 'Control of the query' (I'm not too hot with Access!!)

Regards
 
You have a "Total" for each column of your query you said.
I talk about these "fields" in the query.
 

Users who are viewing this thread

Back
Top Bottom