Count Report

  • Thread starter Thread starter Zanstemic
  • Start date Start date
Z

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]
 
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
 
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



Jeff Boyce said:
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 said:
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]
Click to expand...
Click to expand...
 
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


Zanstemic said:
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



Jeff Boyce said:
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 said:
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]
Click to expand...
Click to expand...
Click to expand...
 
Back
Top