Thanks to everyone that replied on and off list - off to the group by docs
;)
On 8/28/03 5:09 PM, "William R. Mussatto" <[EMAIL PROTECTED]> wrote:
> Mike Morton said:
>> Hey y'all - I have been at this too long today - this is driving me
>> nuts!
>>
>> Table:
>> Date (y-m-d),amount (decimal),de
Mike Morton said:
> Hey y'all - I have been at this too long today - this is driving me
> nuts!
>
> Table:
> Date (y-m-d),amount (decimal),dealercode
>
> I am looking for a query that will give me the sum of each of the
> distinct dealercodes for a specific date range.
>
> Something to the effect o
Hey y'all - I have been at this too long today - this is driving me nuts!
Table:
Date (y-m-d),amount (decimal),dealercode
I am looking for a query that will give me the sum of each of the distinct
dealercodes for a specific date range.
Something to the effect of:
Select (distinct dealercode),sum
