Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by paulostrom

  1. paulostrom

    Top 3 Query Problem

    Thanks for the help r937. Your advice was perfect.
  2. paulostrom

    Top 3 Query Problem

    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?
  3. paulostrom

    Top 3 Query Problem

    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.
  4. paulostrom

    Top 3 Query Problem

    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...
  5. paulostrom

    Limiting Query Results

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

    Limiting Query Results

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

    Limiting Query Results

    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 =...
See more

Part and Inventory Search

Back
Top