Displaying certain data in a Access Report

[jpgonc]

Good day mates, it's the first post here. I am a relatively newbie to MS Access and I've already busted my head to try to find a solution to my case. Let me try to explain what I want to accomplish...

I have a single table filled with data thru importation from Oracle DB. (No primary keys).

I have a field called Expenditure and another called MONTHS. I want the layout to look like this on the report:
---------------------------------------------------------------
Employee Nr 7 Employee Name: Joss Brickenwald
Month: Jan Fev Mar Apr Jun ...

Vacations Salary $9 $12 $6 $7 $5 ...
Expenses Y $12 $34 Null $123 $76 ...
Expense X $45 Null $76 $19 $564 ...
...
----------------------------------------------------------------
And this for every worker...
I could only obtain this:
---------------------------------------------------------
Employee Nr 7 Employee Name: Joss Brickenwald
Month: Jan

Vacations Salary $9
Expenses Y $12
Expense X $45
---------------------------------------------------------
Month: Fev

Vacations Salary $12
Expenses Y $34
Expense X Null
----------------------------------------------------------

This is easy to do, isn't it? But I can't do it. Any help please?

 

[misscrf]

I would first take down all of the fields and see what you need to convert them to. By that I mean pairing them into logical tables that will have pks, and look each other up, and such. In a way that Access can deal with them.

Take a look at this link on normalization for access. Design your db from that point of view, and then plug in the fields from your oracle where they go.

http://www.utteraccess.com/forums/s...r=373096&page=0&view=expanded&sb=5&o=&fpart=1

good luck