M
Miguel
Hi,
I'm trying to make a report that covers several different points of interest
in a database.
Clients are given a Client ID and then a Contact ID for when contact is made
between the client and the company.
The date of the contact is logged in a field (CallDate), and the date they
are called back is also logged (CallbackDate). Finally, when the ContactID
session is deemed to be 'complete', that date is also logged
(CallCompleteDate).
A load of other status fields are also logged, which are simple Yes/No
states (e.g. Status1, Status2, Status3).
I'm trying to create a report that counts the number of Initial Calls,
CallBacks and Completed calls, and in a seperate table on the same report
I'd like a summary of the total number of each Status.
I know there is probably a very straight-forward solution to this, but I
don't have much experience creating reports in Access and my attempts have
so far been rather poor.
If its not too much work, it would be great if the totals could be filtered
down by area (e.g. County), but I'm not overly worried. It would be great if
you could set ranges (Start and End Dates) to filter the report.
Any help pointing me in the right direction would be appreciated!
Miguel
I'm trying to make a report that covers several different points of interest
in a database.
Clients are given a Client ID and then a Contact ID for when contact is made
between the client and the company.
The date of the contact is logged in a field (CallDate), and the date they
are called back is also logged (CallbackDate). Finally, when the ContactID
session is deemed to be 'complete', that date is also logged
(CallCompleteDate).
A load of other status fields are also logged, which are simple Yes/No
states (e.g. Status1, Status2, Status3).
I'm trying to create a report that counts the number of Initial Calls,
CallBacks and Completed calls, and in a seperate table on the same report
I'd like a summary of the total number of each Status.
I know there is probably a very straight-forward solution to this, but I
don't have much experience creating reports in Access and my attempts have
so far been rather poor.
If its not too much work, it would be great if the totals could be filtered
down by area (e.g. County), but I'm not overly worried. It would be great if
you could set ranges (Start and End Dates) to filter the report.
Any help pointing me in the right direction would be appreciated!
Miguel