Results 1 to 2 of 2
  1. 11-27-2019, 07:22 AM #1
    zachariack
    zachariack is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2019
    Posts
    6

    How can i mate tables & query for point system


    Hi anyone can help me to make a table and query for the point system as per the attached excel table ?Click image for larger version.  Name: ranking test.jpg  Views: 19  Size: 75.7 KB  ID: 40313
    Reply With Quote Reply With Quote
  2. 11-27-2019, 11:18 AM #2
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    data:
    TOURN, PLACE, RUNNER
    tourny5, winner, 60
    tourny4, winner, 70
    tourny5, runner, 48
    etc


    create a CROSSTAB query (use the query wizard) with
    tourney as row heading
    place as col heading
    runner as value

    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. There is probably a good RDB way of doing this, point to 2 different tables from same column...
    By oransen in forum Database Design
    Replies: 8
    Last Post: 05-28-2019, 12:00 PM
  2. point matching query
    By Shales in forum Access
    Replies: 5
    Last Post: 04-20-2016, 10:25 AM
  3. Membership Database, Point/Level System Help
    By DRAGONFABLE517 in forum Access
    Replies: 1
    Last Post: 01-21-2015, 12:08 AM
  4. comment system for multiple tables
    By southpawz505 in forum Access
    Replies: 13
    Last Post: 12-18-2013, 01:55 PM
  5. How to create EPOS (electronic point of sale) system?
    By robertmarkdudley95 in forum Access
    Replies: 1
    Last Post: 02-27-2012, 01:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums