Calculating percentages by group (1 Viewer)

I have a query with totals grouped by date and by survey section and I am trying to include a column with the proportions these section totals are of the total for each date. The Totals are an expression sum of several fields.

Date Section Number Prop
A 1 # #/Sum(#) Where Date =A
A 2 # #/Sum(#) Where Date =A
A 3 # #/Sum(#) Where Date =A
B 1 # #/Sum(#) Where Date =B
B 2 # #/Sum(#) Where Date =B
B 3 # #/Sum(#) Where Date =B

I have tried using a second query to calculate the totals by date but joins produce errors when I add it to the original query. This seems like a simple problem but hours of floundering have led me here.

Sal,

I think you will have to give some more detailed information about what you have there. I can't make any sense of:
A 1 # #/Sum(#) Where Date =A
etc.

Maybe the SQL view of your query would be a good start, along with some specific examples of the desired outcome.