Design View

[henp]

I'm trying to group a date and time value by just the date value.

I've set the column to group by in design view do I need to specify criteria?

ELECT [Last Called State - History Table & HistCampaign Table].CampaignID, [Last Called State - History Table & HistCampaign Table].CustomerID, [Last Called State - History Table & HistCampaign Table].AreaCode, [Last Called State - History Table & HistCampaign Table].CalledNumber, [Last Called State - History Table & HistCampaign Table].LastCalledState, [Last Called State - History Table & HistCampaign Table].CallID, [Last Called State - History Table & HistCampaign Table].RecordTime, [Last Called State - History Table & HistCampaign Table].CalledTime, Count([Last Called State - History Table & HistCampaign Table].CalledTime) AS CountOfCalledTime
FROM [Last Called State - History Table & HistCampaign Table]
GROUP BY [Last Called State - History Table & HistCampaign Table].CalledTime
WITH OWNERACCESS OPTION;

 

[Golom]

Try this
[blue][tt]
SELECT L.CampaignID, L.CustomerID, L.AreaCode, L.CalledNumber, L.LastCalledState, L.CallID, L.RecordTime, L.CalledTime, Count(L.CalledTime) AS CountOfCalledTime

FROM [Last Called State - History Table & HistCampaign Table] L

GROUP BY Format(L.CalledTime,"yyyy-mm-dd")

WITH OWNERACCESS OPTION;
[/tt][/blue]