I have a bunch of queries at the moment and they practically all do the same thing. I'm writing a program that makes a top 10 of events. These events occur in a certain area:
I want a top ten of all the Alarms made by 6-2, all of the ChangeDDP's by 6-2, all of the Changepoints made by 6-2 etc etc all the way down to all of the Rests made by General. I currently have to use 25 queries (one for each combination) to get the top 10's into one table. Something I'm definetly not proud off but hey it was the easiest solution so far. Now that I'm adjusting the flaws and bugs I would like to make this in a little bit less queries.
That's why I'm asking you guys for help on this, since my main Access knowledge isn't that big.
Thnx in advance,
DeV
- 6-2
- 6-3
- 6-4
- Pilot
- General
- Alarm
- Change DDP
- Change Point
- OAR
- Rest
I want a top ten of all the Alarms made by 6-2, all of the ChangeDDP's by 6-2, all of the Changepoints made by 6-2 etc etc all the way down to all of the Rests made by General. I currently have to use 25 queries (one for each combination) to get the top 10's into one table. Something I'm definetly not proud off but hey it was the easiest solution so far. Now that I'm adjusting the flaws and bugs I would like to make this in a little bit less queries.
That's why I'm asking you guys for help on this, since my main Access knowledge isn't that big.
Thnx in advance,
DeV