How to compare to fields in Access (maybe using ASP) RRS feed

  • Question

  • User-405462534 posted

    i have two attributes in different tables, BallPicked and BallsDrawn.


    Balls Picked consists of three values e.g. 234

    Balls Drawn consists of four values e.g. 2345


    How can I compare each of the numbers to complete calculations.


    E.g. match 3, add integer to credit say +12

    Monday, April 18, 2011 5:33 PM

All replies

  • User3866881 posted


    I think you should try your best to connect the two tables together with inner join, or something else, thus you can combine the two columns into one temporary table, through which you can compare easily in a DataTable.


    Wednesday, April 20, 2011 11:24 PM
  • User892429821 posted

    I think you should elaborate you problem, as it is confusing that whether you have three fields in first table and four fields in second table and what type of comparison you want, please clarify and elaborate


    Wednesday, April 20, 2011 11:36 PM
  • User1867929564 posted

    Plz explain your problem again.
    How many column are there in each table.
    Each column contain wht value ?
    Wht do you want ? 

    Monday, April 25, 2011 6:52 AM