Please HELP!

[nicofortun]

So i'm kind of new to access, I'm not a noob though. I was using excel and suddenly I exceeded the number of rows so I decided to switch to Access and I'm having certain problems that may look noob at first sight. Please help me, it's driving me crazy.



So I have 3 tables:

One that has four columns (or fields): the code of the client, the month of the sale, the quantity of the sale, and the name of the product.

The second one has the information of the clients such as addresses, phone numbers, the area, the supervisor, the salesman, etc.

And finally, and most importantly, the third one is very complex. You see, the products have gone under a market research and the results came in in a format I can't seem to be able to make it work in access. In the first filed it says "Row Column" (probably a pivot table in excel) where it specifies undistinguished the area, supervisor or salesman. In the next fields I have the products name, each product being a column. This is a big problem because I combine in a query the first to tables with no problem, but I want to add the market research study results summarized either by salesman, supervisor, etc.

I don't know if it's even clear, it's kind of difficult to explain....

Someone? Plz help!

[RuralGuy]

You will probably need to get that 3rd table normalized before you can get anything useful out of it.