Column total based on date

[kraftk]

Im trying to build the below query and sum up the qshipped column based on 3 months sales 6 months and 12 months sales all in separate columns and each individual WHS/Product. How can this be accomplished. I am able to sum up the qship column but it groups it by the refdate which I don't want. Any help would be appreciated.



Thanks

[ranman256]

and remove your GROUP BY in the date range, make it a WHERE
and you still need a SUM field.

for date math use:
DateAdd("d",-2,Date())

or
DateDiff(..)

[kraftk]

and remove your GROUP BY in the date range, make it a WHERE
and you still need a SUM field.

for date math use:
DateAdd("d",-2,Date())

or
DateDiff(..)

Thanks i think i got it now. One last question. i want to be able to sum up the qship based on the number of months from todays date but be able to enter the date into a paramater pop up window. What date formula should i be using?