query

Hi
i have a table  containing the following fields

man_date                          type
test                 wheremeas        measured value
1/1/08 12:00:00                   M1
Hardness                  Top                    2.4
1/1/08 12:00:00                   M1
Width                     Bot                    4.5
1/1/08 12:00:00                   M2
Hardness                  Top                    3.6
2/1/08 12:00:00                   M2
Hardness                  Top                    9.2

What i want to do is create a gird containing the result of a date
range query

ie

 
m1                                         M2
man_date                  Top            Bot
Top            Bot
1/1/08 12:00:00           2.4            4.5
3.6
2/1/08
12:00:00
9.2

the only way i can think of doing this is to write  a query for each
type
then write a query for each wheremeas
then join then together

is there another quicker way

thanks
kevin