Hello everyone!
I need some help. I'm new to access, and i don't know the syntax to write the formulas i need.
Here is what i need help with:
I have 2 tables. For convenience i will name them A table and B table.
So, the tables should look like this A(x,y) = {A11, A12, A13, A21, A22, A23, A31, A32, A33} x would represent the rows and y the columns (y would be the field in the database).
Symmetrically, the B table should look like this: B(a,b) = {B11, B12, B13, B21, B22, B23, B31, B32, B33}. a would represent the rows and b the columns( b would be the field in the database)
Table A has all its fields filled, Table B has fields b=1 and b=3 filled, and field b=2 is empty.
I need field b=2 (B(a,2)) to take the values of field y=2 (A(x,2))
I wrote an update query in design mode and, instead of iterating 3 results, it iterates 9 results, exactly these values (in this order):
A(x1,2)
A(x2,2)
A(x3,2)
A(x1,2)
A(x2,2)
A(x3,2)
A(x1,2)
A(x2,2)
A(x3,2)
Can anyone please explain to me how to do this correctly?
Any help would be appreciated.
Thank you in advance!