Record Count query displayed on a form

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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]")
 
The Query has many records. It counts the records across about 24 TBLs.

Would like to simply call the query into the Form, and display all results
of the query.

Can't figure out which Built-In ActiveX Control I should use.


Ofer Cohen said:
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]")

--
Good Luck
BS"D


[email protected] said:
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?
Click to expand...
Click to expand...
 
Back
Top