Forum Discussion

mikedb3434's avatar
mikedb3434
Copper Contributor
Dec 11, 2024
Solved

Aggregate query question

Hola all! New to Access, building my own DB for race results from a series here in the US for a separate project. I have one table that has nothing but race results.  Columns that matter:  raceCode...
access
Access Web Database
  • mikedb3434's avatar
    mikedb3434
    Dec 12, 2024

    Think this can be closed as solved. Broke apart query to simplest option (select driverName, finish from raceResults where finish BETWEEN 1 AND 5;), repeated for 1-10, then did a count query based on those results. Inefficient, but have the exports of 6 different queries feeding into a .xlsx that's run through Power Query, which manipulates the data the way I'd like to see it. 

mikedb3434's avatar
mikedb3434
Copper Contributor
Dec 12, 2024

Think this can be closed as solved. Broke apart query to simplest option (select driverName, finish from raceResults where finish BETWEEN 1 AND 5;), repeated for 1-10, then did a count query based on those results. Inefficient, but have the exports of 6 different queries feeding into a .xlsx that's run through Power Query, which manipulates the data the way I'd like to see it. 

Resources