Count Report

[Zanstemic]

I'm looking to create a report that returns the number of records for each
representative.

I'm looking for a recommendation for how to return the representative name
and a count.

I'm using the following to control the date range and seems to be working
well.
Between [Forms]![View Reports]![date_start] And [Forms]![View
Reports]![date_end]

 

[Jeff Boyce]

Try a Totals query, GroupBy [Representative], Count [RecordID], WHERE (your
criteria...)

By the way, you posted in a query newsgroup...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Zanstemic]

It seems to be retuning a count for each date.

For example, if the date range is from 5/1 - 6/1, it's returning a count for
each day in the month.
So rep Smith has a count of 3 on 5/5 and a count of 1 on 5/6. Ideally it
would return a count of 4 for the date range.

FYI
Sorry about the wrong location for the post and for the quick response.
Where would be a more appropriate location for this request in the future?

Thanks again

Try a Totals query, GroupBy [Representative], Count [RecordID], WHERE (your
criteria...)

By the way, you posted in a query newsgroup...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I'm looking to create a report that returns the number of records for each
representative.

I'm looking for a recommendation for how to return the representative name
and a count.

I'm using the following to control the date range and seems to be working
well.
Between [Forms]![View Reports]![date_start] And [Forms]![View
Reports]![date_end]

 

[Duane Hookom]

Jeff suggested some good sql advice. You should consider replying with the
SQL that included records for each date. Someone would quickly correct your
SQL to exclude the date from the SELECT clause and only use it in the WHERE
clause as suggested by Jeff.

--
Duane Hookom
Microsoft Access MVP

It seems to be retuning a count for each date.

For example, if the date range is from 5/1 - 6/1, it's returning a count for
each day in the month.
So rep Smith has a count of 3 on 5/5 and a count of 1 on 5/6. Ideally it
would return a count of 4 for the date range.

FYI
Sorry about the wrong location for the post and for the quick response.
Where would be a more appropriate location for this request in the future?

Thanks again

Try a Totals query, GroupBy [Representative], Count [RecordID], WHERE (your
criteria...)

By the way, you posted in a query newsgroup...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I'm looking to create a report that returns the number of records for each
representative.

I'm looking for a recommendation for how to return the representative name
and a count.

I'm using the following to control the date range and seems to be working
well.
Between [Forms]![View Reports]![date_start] And [Forms]![View
Reports]![date_end]