Different Fields

I am using Crystal 10 and Access

I am going to try my best to explain what it is I would like to do.

I would like to find away to have data from different fields to display on a crystal report vertically/across from each other.

For Example:

Field1 Field2
PRD 300
LST 200
MET 205
MIS 650
TTP 745

What I would like is for the information to display on the crystal report like this:

PRD 745 200

As you can see from the fields above, the numbers 745 & 200 are not associated with PRD. I cannot seem to find a way to associate one field information from another field information.

Please let me know if I need to try to clear this up.are field1 and field2 of the same table? If so I'm not sure if that's possible. Even if it was I definately wouldn't recomend it. If not then you have another problem - grabbing 2 different records of the same field at the same time. Why is it that you want it to work like that? A little more information about it would certainly help :)