Count Records in DLookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to count the total records in a Dlookup statement for example
I want to use a Dlookup statement in a textbox on a form to count the records
inside of a query.
 
You should use dcount instead of dlookup

change the word dlookup to dcount, that will return the numbers of record
 
A DLookUp returns the value of just one field in one record.

Use:
=DCount("*","[QueryName]")
to count the total number of records returned by the query.

Fred
 

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

is there a Dlookup to get entire record or multiple fields ?? 8
Dlookup in table won't work 2
dlookup 4
Using Max or DMax in DLookUp criteria? 1
Dlookup on form - help please 2
DLookup 2
Dlookup - new record 5
close form on empty record source 3

Back
Top