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

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

Answer 1

User3866881 posted

Hi：）

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.

Thx

Answer 2

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

Thanks

Answer 3

User1867929564 posted

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