Advanced Filter/Sort Question

  • Thread starter Thread starter Jfs
  • Start date Start date
J

Jfs

I am using Advanced Filter/Sort on a large pass-through
query, all I want to know is the total number of records I
have based on my filter without having to click on the >|
(last record button)

I have found that if I add Sort: criteria (Ascending or
Descending) on one of the columns in my filter then when
the results are returned that datasheet view has Record: X
or XX (filtered)

Is there any way to have this total show without having to
do the above mentioned items.

Thanks
 
If all you want is a count, you could use DCount().

Apply the string you are using for the Filter as the 3rd argument of
DCount().
 
Back
Top