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?
 
G

Guest

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]")
 
G

Guest

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


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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top