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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jfs" <(E-Mail Removed)> wrote in message
news:041d01c3cf1e$5a994af0$(E-Mail Removed)...
> 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