Help in creating query from dailly stock data

[Paolo C]

Hello, I am seeking your help in creating a query. I have a table where list the daily stock data. The fields are symID (is unique symbolID), symName (is the name of the symbol in question i.e. MSFT), Date (trading date), Open (opening price of stock for that date), High (highest price of stock for that date), Low (lowest price of stock for that date), Close (clsoe price of stock for that date) and VolumeDay (daily volume of stock for that date).

I need a query that takes Mon through Fri daily data and summarizes it as follows:

symName (symbol Name)
WeekDate (date for start of week)
StartofweekOpen (the open price of stock at start of week)
Highifweek (the highest price of stock for the week)
Lowofweek (the lowest price of stock for the week)
Closeofweek (the close price of stock at end of week)
AggVolume (aggregate daily volume for the entire week; i.e. add Mon,tue,wed,thus and frid daily volumes)

Thanks in advanced for helping me with this query.
Paolo