Subtracting

C

Celtic__Wings

Okay, I have a report I have built based off of several queries buit I need
it to Subtract the total in the columns, not add it with the Sum option. How
do I do this for a report? Report is built to keep a total of 3 years worth
of information broken down by the week number then the Day of week. Example
of what I need is below:

Week# Day Date Sales Total NOR
32 Tues 20040809 879005 5.476988186
20050808 924072 4.945177432

'Day' = Mon (2 detail records)
45067 0.5318100754

Can anyone help me???
 
Top