Text Field

[Sean]

I ahev a text field in my table that display quantities like this, (5 EA, 16
PAC, 1,000 EA). There is always a space after the number. How do I strip
everything to the right of the space (i.e. EA, PAC) so I can then convert
this field to a number?
Thanks,

 

[KARL DEWEY]

Left([YourTextField], InStr([YourTextField]," ")-1)

and for the right part use --
Mid([YourTextField], InStr([YourTextField]," ")+1)

 

[John W. Vinson]

I ahev a text field in my table that display quantities like this, (5 EA, 16
PAC, 1,000 EA). There is always a space after the number. How do I strip
everything to the right of the space (i.e. EA, PAC) so I can then convert
this field to a number?
Thanks,

It's not actually necessary to do so: Val([fieldname]) will extract just the
leading number.

 

[John W. Vinson]

The following will remove all non-numeric characters from a string

Public Function fSaveNumer2(pPhone As String) As String[/QUOTE]

Just so the OP knows that this function returns a string, and they must use
Val() or CInt() or CCur() to convert it to a number (or currency).