Search results for query: *

Thanks for the help r937. Your advice was perfect.

The later date would work since there is a date column in the same table. I played with that concept this morning for a while but was not successful. How can that query be modified to make a date evaluation?

I understand the logic and I guess a better question might be how can I create an anomaly that doesn't include ties? I'm taking the results from this query and grouping by location for a sum total of the Top 3 days from each location. When that 4th day gets in there my desired results are skewed.

A while back (thread232-1437399)I needed help with a query that would return the highest 3 daily sales amounts from multiple locations. r937 pointed me in the right direction with this query: select location , Daily_Sales from Sales as T where ( select count(*) from Sales...

How about if "Sales" was a query instead of a table? Is it possible to do the same thing for a QoQ?

It's an Access DB. Your solution works perfectly. Thanks r937! :)

Suppose I have a table with the fields "location", daily_sales", and "date". There are 3 different locations and I want the Top 3 "daily_sales" for each location. I know this can easily be done using separate queries for each location (i.e., Select Top 3 Daily_Sales from Sales where location =...