> 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]

Reply via email to