P
Patrick Trotter
I am trying to setup a single report to track our sales dept. The rub
is this...I need to create a report that will show # of sales, total $
sum of sales, # appts run, # proposals generated. This information is
drawn from 3 different tables, and I only want to use one beg. and end.
date parameter for all three (e.g 4-1-04 - 4-30-04). The problem that I
am having is that the information is not necessarily inter-related, so
that the date parameters are selecting only records that match all date
parameters. For example, a salesman may run an appt on Apr 26, generate
a proposal on Apr 29, and not sell the acct until May 3. The example
record is being completely excluded from the report, but I still need to
account for the appt, and proposal from the month of Apr.
I realise this is confusing, but any help would be appreciated.
Patrick
is this...I need to create a report that will show # of sales, total $
sum of sales, # appts run, # proposals generated. This information is
drawn from 3 different tables, and I only want to use one beg. and end.
date parameter for all three (e.g 4-1-04 - 4-30-04). The problem that I
am having is that the information is not necessarily inter-related, so
that the date parameters are selecting only records that match all date
parameters. For example, a salesman may run an appt on Apr 26, generate
a proposal on Apr 29, and not sell the acct until May 3. The example
record is being completely excluded from the report, but I still need to
account for the appt, and proposal from the month of Apr.
I realise this is confusing, but any help would be appreciated.
Patrick