Removing Zeros From A Field

[LHG33]

I have a field called Account, which is also my Group 1. Unfortunately, the same account number has been keyed in normally (ex. 52001) and with zeros (0052001). Crystal Reports sees this as two different numbers and so the same account appears twice on my report.

How do I write a formula that will ignore the zeros and combine 0052001 and 52001? By the way, Account is a string in the database (don't know why b/c it's really a number...)

Thanks!

 

[dgillz]

write a formula: Val({Account}). And group on this formula instead of the database field. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[LHG33]

Thanks so much! It worked!