S
Sherry
I have bult a contact tracking database and need some advice about how to
build a report. I have a list of customers that I contact on a regular
basis. I have set up a form that loads these contacts into a table. What I
am now trying to do is build a report for a monthly review of those contacts.
I want it to look like this:
Company name Current Balance 30 day balance
Date of contact Notes regarding contact
Then what I would like is to have a total of the balances at the bottom of
the report. What I am running into is since I have multiple contacts during
my time period, if I sum the balance on the report it is summing the balance
multiple times (as many times as I have contacted them). Any ideas?
build a report. I have a list of customers that I contact on a regular
basis. I have set up a form that loads these contacts into a table. What I
am now trying to do is build a report for a monthly review of those contacts.
I want it to look like this:
Company name Current Balance 30 day balance
Date of contact Notes regarding contact
Then what I would like is to have a total of the balances at the bottom of
the report. What I am running into is since I have multiple contacts during
my time period, if I sum the balance on the report it is summing the balance
multiple times (as many times as I have contacted them). Any ideas?