Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Posts
    3

    Unanswered: Howt compare fields in Access

    Hi I have a rugby prediction game where users predict each team's score. I want to put that in 2 separate variables for each team. Now when the administrator puts in the real scores with dbnvigator it goes to a table called matches. I want to use a ADOTable for table matches to compare the real score and the variable for each team's score. Can someone help please...

    I think it's something like ADOTable[field name] ...

  2. #2
    Join Date
    Nov 2011
    Posts
    413
    When you say compare, do you mean the get the difference between the two? One field is Prediction and the other Final? How do you want this display, in a form or qry?
    Prediction = DLookUp("[YourFieldName]","YourTableName")
    Final = DLookUp("[YourFieldName]","YourTableName")

    (Prediction & Final of course will be whatever field names you want to use)


    HTH

Tags for this Thread

Posting Permissions

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