Averaging totals of certain days with a month

[bluke]

a request came accross my desk to find holidays sales in relation to the same days of the week for other weeks. For example, Thanksgivings sales compared to each of the 2 thursdays prior and the 2 thursdays after. Anyone know of a way of pulling this data so I have it all in one query - Thanksgiving, Thanksgiving+1, +2 and -1 and -2 (the numbers representing weeks from holiday

Thanks.

Brian.

 

[Guus2005]

first you have to create a table with all the holidays, Names and Dates. Where also Thanksgiving+1 e.t.c. is stored. then Join it with the Sales table.

HTH