Help Request - Summerizing record counts

[spmiyamoto]

I could use some help resolving an issue I'm having. The query needs to summerize the number of visits for a given ClientNumber over a specified date range. The results would need to be:

ClientNumber NumberOfVisits
1001 2
1005 1
1009 2
etc.

Thanks,
Steve

[June7]

Please provide data as tables built in post (Advanced editor) or attach file. Also, post code as text between CODE tags. Images are not appreciated as cannot copy/paste.

You want an aggregate query. Access has a wizard for that. In query design view click Sigma (Totals) icon on ribbon.

Need to deal with time portion of value. Consider something like:

SELECT ClientNumber, Count(*) As CntVisits FROM ClientVisits WHERE DateValue(DateOfVisit) BETWEEN [enter start date] AND [enter end date] GROUP BY ClientNumber ORDER BY ClientNumber;

Instead of aggregate query, could build a report and use its Sorting & Grouping features with aggregate calcs. This allows display of detail data as well as summary info.

[Welshgasman]

Isn't this the same question?
https://www.accessforums.net/showthr...722#post506722