Hi,



  I was wondering if anyone could give me some pointers on what I am trying

to do.



  I have a bunch of records stored in an Access Database (yuck, I know).

They are records of transactions between a plant and a customer detailing

Parts recieved and parts rejected for each month.



 What I am trying to do is create an aspx page which will take all the data

from the access database using a SQL statement, add up the numbers for each

plant, display them in a row on a table and go through until all the plants

are displayed.  This would be easy enough but I need this sorted from teh

order of highest parts rejected/parts shipped to lowest parts rejected/parts

shipped.



  Here is my problem.  How do I do something like this?  Where should I sort

the data.



  1.  Create a summary table which has all the information calculated from

the detail records.  Then teh calculations can be done on teh db and a

simple query can pull up all the information I want.  This is an

unattractive and wasteful option to me though.



  2.  Somehow use only the detail records, do the calculations using code

and somehow sort it and display it in a table (the part I don't know how to

do).



Any insights will be much appreciated



Thanks in advance

-Mike