kdaymayday
New member
- Local time
- Yesterday, 17:58
- Joined
- Aug 8, 2012
- Messages
- 1
I want to arrange my data so that it is sorted by month,
What is the Formula to make it sort by month, and the correct formula to put in design view in the detail or footer for the subtotals and totals?
MONTH
NAME SQUARE FEET SUM OWED
NAME SQUARE FEET SUM OWED
NAME SQUARE FEET SUM OWED
SUBTOTAL =(Subtotal[SQ FT]) =(Subtotal[Sum])
MONTH
NAME SQUARE FEE SUM OWED
SUBTOTAL =(Subtotal[SQ FT]) =(Subtotal[Sum])
GRAND TOTAL =(Sum[SQ FT]) =Sum[Sum])
Please tell me what the correct way to program this in an Access report. :banghead:
What is the Formula to make it sort by month, and the correct formula to put in design view in the detail or footer for the subtotals and totals?
MONTH
NAME SQUARE FEET SUM OWED
NAME SQUARE FEET SUM OWED
NAME SQUARE FEET SUM OWED
SUBTOTAL =(Subtotal[SQ FT]) =(Subtotal[Sum])
MONTH
NAME SQUARE FEE SUM OWED
SUBTOTAL =(Subtotal[SQ FT]) =(Subtotal[Sum])
GRAND TOTAL =(Sum[SQ FT]) =Sum[Sum])
Please tell me what the correct way to program this in an Access report. :banghead:
Last edited: