Record Count query displayed on a form

G

Guest

I have a Master Form from which I am able call all of my administrative
tasks.

Now I have a query that does a number of record counts (about 30). I want
to be able to display the query results on the form.

How do I do this?
 
O

Ofer Cohen

If this query has only one record return, then, in the form create a text
box and in the control source of tis text box write
=DlookUp("[FieldName]","[QueryName]")
 
Top