Field Values to Column Names in MS Access SQL -

how convert this:

name    attributes ----    ---------- john    height john    weight john    age mary    shoe size mary    hair color mary    eye color  this:      height  weight  age 

name , attributes 2 fields in access table. want convert attribute values fields names based on value in name field. using ms access 2010.

i presume effect of select ??? table name="john"

add 'value' field table read this:

name  attributes  value ----  ----------  ----- john  height      172 john  weight      87 john  age         25 mary  shoe size   9.5 mary  hair color  brown mary  eye color   blue 

you can use 'transform' , 'pivot' in access

transform first(value) select name mytable group name pivot attributes