Create an Access DB
Budget: €8 – €30 EUR
Hi,
Very easy task for a guy with skill in access.
So my query is the following one.
I have one table composed like this where the value could only be 1 N or 2
M1 M2 M3 M4 M5
1 N 2 1 2
N 2 1 N N
And in other side I have a temp table called A with the values of 1 N 2 for each column per instance
M1 M2 M3 M4 M5
1 10 14 7 8 9
N 13 16 17 21 12
2 4 6 18 24 30
Each combination is unique.
The goal is to create a new table with the values of the temp table so for instance the result will be the following one
M1 M2 M3 M4 M5
10 16 18 8 30
13 14 7 21 12
The temp Table A could be erased thanks a button
This is not nothing tricky.
I want it soon as possible don't expect me too accept high offer.
Thanks
Very easy task for a guy with skill in access.
So my query is the following one.
I have one table composed like this where the value could only be 1 N or 2
M1 M2 M3 M4 M5
1 N 2 1 2
N 2 1 N N
And in other side I have a temp table called A with the values of 1 N 2 for each column per instance
M1 M2 M3 M4 M5
1 10 14 7 8 9
N 13 16 17 21 12
2 4 6 18 24 30
Each combination is unique.
The goal is to create a new table with the values of the temp table so for instance the result will be the following one
M1 M2 M3 M4 M5
10 16 18 8 30
13 14 7 21 12
The temp Table A could be erased thanks a button
This is not nothing tricky.
I want it soon as possible don't expect me too accept high offer.
Thanks