[calstan]

If I have a single table with the following fields:

location, date, status, Value1, Value2, Value3, etc.

north Jun1 Y 3 2 2
north Jun1 N 1 1 3
south Jun1 Y 5 2 1
South Jun 1 N 2 1 0
North Jun7 Y 2 3 2
North Jun 7 N 1 1 1


How can I use SQL or code to pull records from this table into a query and/or another table into the following format: by location and by individual Value (numbers represent the count of the values by status each week-entries are made once a week)?

-------
North

Value1

---------- week# 1 2 3 <-Column Headings

Row Head> # Y -- 3 2 etc
Row Head>-#N -- 1 1 etc

Value2

---------- week# 1 2 3 <-Column Headings

Row Head> # Y -- 3 3 etc
Row Head>-#N -- 1 1 etc


Thanks for the help!!!