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

    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
    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)


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