In one of my subreports I get an error(#Size) for some values. What ato do?
Similarly, I get an error(#Type) for some values. What to do?
In one of my subreports I get an error(#Size) for some values. What ato do?
Similarly, I get an error(#Type) for some values. What to do?
Vmdr Rs.3,000.00
F-04683 R. Gnana Guruparan Malaysia Rs. 10,000.00 Ashram L
F-04684 Bimal Sharma Malaysia Rs. 6,000.00 AK L
F-04685 Major ( R ) Sachithananthan Malaysia Rs. 5,000.00 SCLRF L
F-04686 Koh Lek Heok Malaysia Rs. 5,000.00 SCLRF L
F-04697 Kamal Bhatt & Prakirti Bhatt Australia Rs. 5,000.00 SCLRF D
Rs. 10,000.00 AK
F-04698 Ketan Bhatt Australia Rs. 10,000.00 AK D
F-04699 Asha Ramith South Africa Rs. 2,500.00 Ashram RO
F-04700 Radha Ramluckan South Africa Rs. 1,000.00 Ashram RO
TOTAL #Size!
Ok but are you just summing the numerical part? Is it number datatype? Integer? Double? Or what?
Still not enough info to assist.
And what about the #Type error you also mentioned?
Yes I am summing the numerical part Double.
In a similar case in another report a #Type error occurs for Totals.
You are still not providing useful information.
How do you expect anyone to be able to provide a sensible answer to this
In an attempt to move this forward, I copied the info in post 3 to a text file, imported it to Access, separated out the currency values, saved as double (as you stated)In a similar case in another report a #Type error occurs for Totals.
I then created a report with totals in the report footer
As you can see, it works fine.
See attached
Tank You for all the trouble you have taken. But the errors occur occassionally. I will have to monitor under which circumstances these occur. I will also have to check the querry on which the report is based.You are still not providing useful information.
How do you expect anyone to be able to provide a sensible answer to this
In an attempt to move this forward, I copied the info in post 3 to a text file, imported it to Access, separated out the currency values, saved as double (as you stated)
I then created a report with totals in the report footer
As you can see, it works fine.
See attached
Thank You for all the trouble you have taken. But the errors occur occassionally. I will have to monitor under which circumstances these occur. I will also have to check the querry on which the report is based.
If the errors occur occasionally then the cause is probably the data itself. You probably are getting non numerical values in fields - sometimes they aren't even visible i.e. space or special character... in which case you need to do a character count to check....