[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....

[brucevde]

Create a Formula Field that converts the text data to a number.
You can then create a Summary field based on the Formula.
Place the Summary Field at the bottom of the report.

[intellogo]

Brucevde...baby,

This has been solved..I also knew that i have to convert from the string to numeric stuff, but did not know the syntax neither in Crystal syntax nor in Basic Syntax. But i hunted on the net and got it working perfectly as i want...

Thank you for telling me how to use & implement the Formula Feild and place a Summary on that...i never knew this..

Now pls focus on the other 2 issues..This Arithmetic one is SOLVED

Awaiting ur friendly replies.