Hello everybody,
I'm willing to move a usefull file excel in to access in order to have report and everything else.
As you can see the excel file is based on two sheets (figure 1.jpg and 2.jpg).
The sheet2(foglio2) has all the main data, but the data on column "F" are calculated by this formula "=CERCA.VERT(D2;Foglio1!$A$2:$D$25;CONFRONTA(E2;Fo glio1!$A$2:$D$2;0);0)" (sorry is in italian excel) based on the values that are on sheet1 (foglio1). Like in a matrix system , if you have 2 values the file returns the 3°.
I have create my tables and my relation figure 4.jpg but my first query already is ambiugous and doesn't run.
So i think my normalization needs same help.
Thanks in advice.
Alessandro