> SELECT txt, SUM(num) > from table > where date between '01/01/2003' AND '12/12/2004' > group by txt
Thanks for replying! I figured it out within about 2 minutes of sending it. I told you I was half asleep! I have to say... Judging by this list recently... Half the rest of you are asleep! Paul -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
