Help retrieving values from table row+column header

[matrekz42]

Good Afternoon,

I'm trying to query the following:

I have a table that has a row name and then a specific column name for that given row name.

(row)
Rate  Segment Segment2
1        56      5
2        90      12
3        100     15
4        25      45
5        13      2

I have a query that will return the following values as independent fields, showing record 'x' = Rate1, Segment2...

How can I show the value of the Column 'Segment2' = 5 for Rate1?

I've tried Dlookup's, etc, but no success. Any help/suggestions is greatly appreciated.

[ADezii]

1. SQL assuming Table Name is Table1 and Results Field is named [Result]:
   

   SELECT "Segment2=" & [Segment2] & " for Rate " & [Rate] As [Result]
   FROM Table1;

2. OUTPUT:
   

           Result
   Segment2=5 for Rate 1
   Segment2=12 for Rate 2
   Segment2=15 for Rate 3
   Segment2=45 for Rate 4
   Segment2=2 for Rate 5