On 21 Apr 2005 14:39:48 -0700, mchen716@gmail.com wrote:

>Hi Hugo,
>
>I'm sorry I didn't post the data correctly. The script seems to work
>now. I noticed that you took out the post date. Is that the only way
>that this script can work?
>
>Thanks,
>Michelle

Hi Michelle,

It's not the only way, but you have to do _something_ with post date,
you can't just leace it as it was in the SELECT. Check the following two
rows from your sample:

>340 User 3/9/2005 3/18/2005 16.5
>340 User 3/10/2005 4/4/2005 12.5

Both have a tran_date in the same week, so they should be combined. But
they have a different post_date. Which one would you want to show?

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)