Any database/excel experts on here?

[Davyred]

I\'ve just started running a scorecaster at work. what I need is an Access or Excel file to collate the names and weekly scores, and be able to print off a sort of league table every week. On top of this, there is a 4 weekly prize for the best total score over the 4 weeks, I need this printing out on a highest/lowest total format, showing each weeks score.

I\'ve done a rough thing in Excel, but I\'d have to sort the data out every week, is there anyone out there with any ideas, or a version of a similar thing? Is Excel the right application to use (not as good with Access)


[Edited on 6/1/2006 by Davyred]

 

[Charlie_Thompson]

Excel should be fine Davy. As for the detail I\'ll have a think.

 

[Charlie_Thompson]

Shouldn\'t be too hard Davy I\'m back at work monday I\'ll have a look.

You will only need to enter the new data and the correct formulas will sort and display each weeks scores and calculate the best 4 weekly score. If the scores are held in an online database you can link to that and shouldn\'t need to even enter the scores.

Promises Promises

 

[Davyred]

Cheers Ell

 

[Charlie_Thompson]

did you get my pm davey?

 

[Charlie_Thompson]

He did by the way but chose to ignore it