[RESOLVED] Arithmetic sum not calculating correctly....

[intellogo]

Hi..VBForumers,

Reporting toolkit: Crystal Report 11
Front End: Visual Basic 6.0
Back End: MS ACCESS 2000

I am able to perfectly generate reports.
But....
In my report i have a field: "Price" which is of datatype TEXT at the MS ACCESS 2000 database. Actually my s/w in VB6 and MS ACCESS does not anywhere need to calculate any numerical figure, becoz the scenario is like that...so for that reason i did not use the NUMBER kind of datatype in my database.

But now in my reports, I have to mention the total PRICE at the bottom of the report for the various records queried. And i am noticing that it is not summing it up, eventhough i have 2 records, one having 145.50 and the other having 155.75 as the price, respectively...At the bottom itis only showing the topmost report's proce.

How do i correct it.
Awaiting status reply....