>Is this possible? I am working on setting up paging on a form and I don't want to duplicate the joins and filters in a second query that just returns the count. I've seen an example of creating a temp table and inserting the results of a stored procedure into that table but I wanted to see if there was an easier way.
Hi Mike,
Please review this thread
Re: Could not figure out if this possible Thread #
1385189 I think it's exactly what you're asking.
If it's not broken, fix it until it is.
My Blog