Got it--- Is this the most effective way?

  • Thread starter Thread starter jonudden
  • Start date Start date
J

jonudden

=DLookUp("[countoffield]","qryName"
Is this the most effective way to accomplish this
 
=DLookUp("[countoffield]","qryName")
Is this the most effective way to accomplish this?

I suppose, as long as the query returns just 1 record.
But then you haven't said what you are trying to accomplish.
 
On Fri, 15 Jul 2005 03:35:46 -0500,
=DLookUp("[countoffield]","qryName")
Is this the most effective way to accomplish this?

Generally, no; it depends on what qryName is and what you might be
attempting to do. Since you don't say what you're trying to do (at
least not in this thread) it's more than a mite difficult to suggest a
better way to do it!

If qryName is a Totals query doing a count, you can save one layer of
logic by doing the count in an equivalent DCount() function call; or,
you can do counts directly in the control source of textboxes on a
form or report footer.


John W. Vinson[MVP]
 

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

Similar Threads

SQL statement with two ";" 1
Being nosey 2
Valuelist in Combobox 2
Valuelist in Combobox 1
running query 1
Raspberry Pi 400 any good? 4
Best games of the last decade 5
Giveaway Mass Effect 2 is free 9

Back
Top