Thank you all so much for the help

well the day i need is January 1 2007 forward it is in the future becasue it is the day the information is to be deleted from our system.

also im...

can this be adjusted to call for just 2004?

thanks

nicely done

thanks  again

so do you think this is just to much to accomplish on the SQL end then?  To preface this a bit more I'm not a programmer (yet anyway, I have...

I looked around a bit more more and was able to find tables where instead of issue there is a delivery date.  I tried to pull together what you gave...

unfortunatly I'm not allowed to make changes to the data but the issue system actually works pretty well because it is for magazine data which is all based off issue. ...

ok here is part of issue 1 of outlet 1 in city 101

[city_code], [outlet_code], [book_code], [issue_year], [issue], [sold_units], [active]

101, 1, FD,  2005, 1, 2, yes

101, 1, AQ,  2005, 1, 7, yes

101, 1, AK,  2005, 1, 9, yes

and yes the issue always points toward the...

well the combination of the issue_year and issue is sort of a date it points to a specific week in each year  ie issue 1-4 = Jan, 5-8= Feb, 9-13=Mar

I believe the most columns this query will have will be 26.  the first 2 are city and outlet information and the next 24 would be sales info with the...

pardon my newbieness but im not sure exactly what the cast part of that shows but maybe if I am more specific i can help some

I am trying to...

sounds like a good plan. I am unsure how though is that inside the Sum function?

thanks