ACCESS 에서도 pviot 을 지원하는지 모르겠네여.

mssql 2005 의 경우 pivot 을 사용하실수 있습니다.

 mssql 기준으로 테스트 했습니다...

--1.임시테이블 데이터 입력
Declare @tb Table
(
 ymd varchar(10),
 usd decimal(10,2),
 eur decimal(10,2),
 jpy decimal(10,2)
)

declare @i int
Set  @i = 1
while(@i < 100) begin
 
 insert @tb(ymd , usd , eur , jpy )
 Values (Convert(Varchar(10), DateAdd(day,@i*-1,GetDate()),121) , 1000.12 + @i*1.15  , 3000.12 + @i*9.15 , 2000.12 + @i*5.95 )
 Set  @i =  @i + 1
end

--2.데이터 확인
Select * From @tb

--3.unpivot
Select ymd , pri , na from
(
 select ymd , usd , eur , jpy
 From @tb
) as p
unpivot
(
 pri for na in (usd,eur,jpy)
) as dd

 
--4.pivot
 
select na , [2014-06-15],[2014-06-14] from
(
 Select ymd , pri , na from
 (
  select ymd , usd , eur , jpy
  From @tb
 ) as p
 unpivot
 (
  pri for na in (usd,eur,jpy)
 ) as dd

) as p11
pivot
(
 sum(pri) for ymd in ([2014-06-15],[2014-06-14])
) as p12

TRANSFORM max(val) as MaxValue
SELECT col
FROM
(
  SELECT [ex_Date], '[USD/KRW]' as Col, [USD/KRW] as  val
  FROM Exchange
  UNION ALL
  SELECT [ex_Date], '[EUR/KRW]' as Col, [EUR/KRW] as val
  FROM Exchange
  UNION ALL
  SELECT [ex_Date], '[JPY/KRW]' as Col, [JPY/KRW] as val
  FROM Exchange
  UNION ALL
  SELECT [ex_Date], '[CNY/KRW]' as Col, [CNY/KRW] as val
  FROM Exchange
)
Where Ex_DATE >='2014-06-01'
GROUP BY col
PIVOT [EX_Date]

이렇게 하니 됐습니다 ^^ 참고하세요 ㅎㅎ

Access 2003 이용