How do i select a top5 and then a(other) column to graph

[Steven.Foy]

Wonder if anyone knows the answer....

i have a query which runs and produces a set of results. There are always greater than 5 results. i want to view these in a report, but i would like them presented as the TOP 4 and then a column containing all the other data added together.

i know i can use the TOP n statement in the sql to retuyrn only the top n number of results, but does anyone know how i can sum the remaining rows and give them the id (other?).

Am open to any ideas!


Also if anyone has any thoughts about the Sub totals query i asked about previously i'd be keen to hear from them!

 

[Len Boorman]

Best advice I can give is the method I use for all charts in Access.

Use Queries and if necessary Table/s to gather together all of the data you want to chart and then do the chart

Sounds to me like you maybe want a Top 4 query, An Average of the Rest Query and then A UNION Query to provide a single recordset for charting

Len B

 

[Steven.Foy]

Thanks,

I'd actually managed to work out in the end that that was the sensible(or easiest way to do it!) its always the simplest tasks which seem to have you making more queries than you think you need!