J
Jerry
I have a large datebase that updates every day with sales
reports. I want to use Access to generate reports on how
many were sold by type and rep by day. I want the report
to show each day's figures along with monthly totals. Is
it better to build a number of queries that answer each
individual data point and build a report around multiple
queries or is it better to build a querie that gets all
of the answers and then create a report that feeds off of
it? My table looks something like this:
Sold Order Rep Type Due Date
3/25/05 11265 Blanca Basic 4/27/05
3/25/05 11267 Blanca Basic 4/28/05
3/25/05 11275 Debbie Custom 4/27/05
3/29/05 11278 Debbie Custom 5/1/05
3/30/05 11279 Blanca Custom 5/1/05
I would like to see a report that looks something like
this:
Sold Rep Basic Custom
3/25/05 Blanca 2 0
3/25/05 Debbie 0 1
Total 2 1
Any suggestions?
Jerry
reports. I want to use Access to generate reports on how
many were sold by type and rep by day. I want the report
to show each day's figures along with monthly totals. Is
it better to build a number of queries that answer each
individual data point and build a report around multiple
queries or is it better to build a querie that gets all
of the answers and then create a report that feeds off of
it? My table looks something like this:
Sold Order Rep Type Due Date
3/25/05 11265 Blanca Basic 4/27/05
3/25/05 11267 Blanca Basic 4/28/05
3/25/05 11275 Debbie Custom 4/27/05
3/29/05 11278 Debbie Custom 5/1/05
3/30/05 11279 Blanca Custom 5/1/05
I would like to see a report that looks something like
this:
Sold Rep Basic Custom
3/25/05 Blanca 2 0
3/25/05 Debbie 0 1
Total 2 1
Any suggestions?
Jerry