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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto populate value from one task to another in MS PROJECT 0
Solved Disk Full error message when exporting PDF 0
Data consolidation 0
Populate a table based on check box status 2
Format column widths from one table to a separate table on same page 1
Hyperlink fails to open on the first click 0
Calculate the median value before a specified list 0
Word 2016 opening sooo slow 0

Top