Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

String Problem

Status
Not open for further replies.

sl71

IS-IT--Management
Apr 24, 2003
4
AU
I have a Database which uses a String Data Type for an Invoice Number. I have designed a Crystal Report to prompt for value(s) which are used as Invoice numbers to query the Database.
I have based the Group Sort on the Invoice Number.
My problem is during a print preview numerals which are not in the record set are displayed.

i.e Invoice Number 200 to 220 will display the following:

200
201
202
203
204
205
206
207
208
209
21
210
211
etc

I understand why this is occuring (because the number is stored as a string) but was wondering if there is a way to filter the non required numbers out.

Thankyou for your help.

 
For the above case, you could suppress using mid({your.field}, 3, 1) = " ".

You could also try ToNumber({your.field}) to turn it back into a numeric value.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top