Top Values

C

Chey

I need some assistance on using top values in a query that I veiw in a
report. Is there a way to first filter by a column then do top values? Or
does it base it off of the whole thing?
 
B

BruceS

Chey,
A little quick expiramentation shows that the filter is applied first and
the result is based on the filtered set.
Bruce
 
C

Chey

So how can I get this fixed. I have the where clause on a command button.
How do I get the query to filter the correct TA Number and then do the top 13?
 
Top