Advanced Filter/Sort Question

[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

 

[Allen Browne]

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().