Too many hours - brain not working.....

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

Re: Too many hours - brain not working.....

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 of:

Re: Too many hours - brain not working.....

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),dealercode I