Access or Excel

M

Mickey

Hi, I use MS Excel to create and maintain quite a few tournament tables for
chess. In Excel I am having a problem getting the tables sorted by player
results, these can easily be ranked but the individual match results tend to
get mixed up.

Is it possible to use MS Access to create tournament tables and get them
sorted by player points whilst maintaining the correct match results for
each player?. If so can someone point me towards a useful related web site
or similar where I can learn a little more?

Many thanks,
Mickey
 
M

Mickey

Hi Joseph,
Thank you for your response. The tournament table is a results table such
as a football league table. The difference being that individual match
results are also shown at the same time as points scored. An example can be
seen at
http://bfcc-online.org.uk/files/tourneys/memorials/mitchell/mitchell.htm

I have been searching the web for a template but have not found anything
yet. I am temporarily using a shareware program but this is a little
temperamental.

Cheers,
Mickey
 
M

MacDermott

When you sort in Excel, it's important to highlight all of the columns you
want re-arranged before you apply the sort.
My guess is that you'll find it easier to learn and apply that principle
than to master Access.
 
M

Mickey

Hi,
Mmm, not sure about this. Excel only offers the option to sort on 4
columns, therefore I can sort by Points Scored and by up to threeplayers but
Excel does not then maintain the individual match results correctly.

Mickey
 
M

Mickey

Hi Joseph,
Thx for the reply again, I will see what I can find out at the Excel
newsgroup as you suggest. Rather than post an attachment it is probably
best if Igive you a link to a table of the type I am using -
http://bfcc-online.org.uk/files/bfccopen/semis/s112.htm whilst a 'sorted'
table can be found at
http://bfcc-online.org.uk/files/tourneys/memorials/mitchell/mitchell.htm

(Right click on the first table to download into Excel)

To be fair I do not expect you to trouble with this any longer and I do
thank you for your help. I see a lot of Excel tableson the web for chess
resutls and none are using sorted tables, theonly place I see sorted tables
is a site whose tables are in a .NET setup, hence the database soloution.

Mickey
 
Top