Hi all I can do this in the report writer but I want to be able to export this data to a WK1 file.
So, is there a way to do this? SELECT IMON(xdate),IYR(xdate),Sum(col1),Sum(col2)... FROM table GROUP by IMON(xdate),IYR(xdate) I am trying to get something like this 1 2002 125 $5,000 ... 2 2002 145 $5,500 ... And if possible make another Select statement that would group by the week. I know I am Dreaming but my brain just can't seem to work this out. Thanks marc __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com
