SQL (beginners) question. Select distinct(date), customer, cnt(items).....

[b. hotting]

Hi,

Which msAccess SQL guru can help my out here?
i would like a list of sales(count) per day per customer

end result, something like:
distinct(date), customer, cnt(ItemsSold)
20/5/2005, c1, 10
20/5/2005, c2, 1
20/5/2005, c3, 8
21/5/2005, c1, 5
21/5/2005, c2, 15
etc...

select distinct(format(InspDatTim,"dd/mm/yyyy")) as distinctDate, ...
from sales
....
thanks,
you are my hero...

[Rick Brandt]

b. hotting wrote:

Hi,

Which msAccess SQL guru can help my out here?
i would like a list of sales(count) per day per customer

end result, something like:
distinct(date), customer, cnt(ItemsSold)
20/5/2005, c1, 10
20/5/2005, c2, 1
20/5/2005, c3, 8
21/5/2005, c1, 5
21/5/2005, c2, 15
etc...

select distinct(format(InspDatTim,"dd/mm/yyyy")) as distinctDate, ...
from sales

SELECT DateField, Customer, Count(ItemsSold)
FROM TableName
GROUP BY DateField, Customer

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[b. hotting]

thanks Rick,

it was the
"group by format(DateField,"dd-mm-yyyy"),"
that set me off.
thought i could use the alias

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:wt*****************@newssvr12.news.prodigy.co m...

b. hotting wrote:

Hi,

Which msAccess SQL guru can help my out here?
i would like a list of sales(count) per day per customer

end result, something like:
distinct(date), customer, cnt(ItemsSold)
20/5/2005, c1, 10
20/5/2005, c2, 1
20/5/2005, c3, 8
21/5/2005, c1, 5
21/5/2005, c2, 15
etc...

select distinct(format(DateField,"dd/mm/yyyy")) as distinctDate, ...
from sales

SELECT DateField, Customer, Count(ItemsSold)
FROM TableName
GROUP BY DateField, Customer

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com