J
jonudden
=DLookUp("[countoffield]","qryName"
Is this the most effective way to accomplish this
Is this the most effective way to accomplish this
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
fredg
=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.
J
John Vinson
On Fri, 15 Jul 2005 03:35:46 -0500,
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]
=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]