Compare numeric fields in a query

Comments

1 comment

  • Avatar
    Tom Coppedge

    Could you please provide an example?  I assume you mean to say that, if I have 2 different fields in the same database, each holding numeric data, I can write a query like:
    Field1
    is equal to
    [Field2]    <--- what kind of bracket?

    ...and it will return all records where the value of Field1 equals that of Field2 ?

    Though I cannot find a specific article or help text to confirm this, I was able to create a query comparing the value of the Email field with that of a text field, using the same format as above, and it seemed to work.  In my test, I compared two fields' email values, placing the second field name in square brackets:

    Email
    is equal to
    [EmailField2]

    0
    Comment actions Permalink

Please sign in to leave a comment.