Data Layout

Hello,

I have a database with the following fields in a table:

TIME (in format 01/01/2009)
SALES (in format £1000)
PROFIT (in format £1000)

I am trying to create a pivot report/query to display:

1. sales, profit by week number(left column) against year (row heading). Also to calc variance of sales, profit; for week number compared to year.

I know how to format date to week no, using Format([TIME], "ww") however this results in single character for week numbers 1-9, thus when sorting it displays 1, 10, 2, 20....

Also when creating the pivot report/query the sales & profit figures are not summating for each week number.

2. Sale, profit showing year-to-date, this year against last year. For example, if todays date is 17/10/09, i want to show sales and profit figures for last year 01/01/08 to 17/10/08 against 01/01/09 to 17/10/09.

Any able to help?