Count Records in DLookup

[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.

 

[Guest]

You should use dcount instead of dlookup

change the word dlookup to dcount, that will return the numbers of record

 

[fredg via AccessMonster.com]

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

 

[Guest]

Thanx a lot fellas!