Search results

  1. J

    Access version of Transpose?

    Hi, I've got two tables in Access. The first contains 300 column headers running from top to bottom, i.e: Title First Name Surname .. .. The second table contains the corresponding data entries for 1000 customers running from left to right, i.e: MR Trevor Smith .... MRS Mary...
  2. J

    Ranking

    That's great, thanks once again.
  3. J

    Ranking

    Just one more thing... I've attempted to adapt the code slightly so that if teams are level on points and goal difference they are then ranked by the number of times they've scored. However, in the example below, teams C and E are both given a postion of 2 (rather than C being 2 and E being 3)...
  4. J

    Ranking

    That's excellent, thanks to both of you for your help.
  5. J

    Ranking

    Ok thanks, but how do I create the "counter" function?
  6. J

    Ranking

    I've got a football table ranked by Points and Goal Difference: e.g. Team Pts Goal Diff C 4 +2 A 4 +1 B 0 -3 and I want to introduce another...
Back
Top Bottom