Unanswered: Number of records is ticking up as crystal reads databases
Hi there can anyone help
I have been asked to design a report for spendage on mobile phones over the year.
I have 12 seperate databases with the mobile information Apr03 to March 04
which are all linked together by the phone number
Apr --(Linked by Mobile no) --> May --- (Linked By Mobile no) --->all the way to ----> Mar (Linked By Mobile no)
then the March mobile database link into a database which has a list of all the mobile numbers and costcentre (Costcentre are locations within the company) then that links into the company Hierarchy database so it looks like this.
Mobiles April03 ---(Linked by Mobile No. ) ----> Mobiles March04 --(Linked By Mobile No) -----> Mobile Vs Costcentre --- (Linked By Costcentre) --------> Company Hierarchy.
When i run the report the grand total of record that should be in the report start ticking up , has anybody had this trouble before and do you know how to solve it, This is a drill down report i am making and am using MS Access 2000 for my databases