Re: String Manipulation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 03/23/04 

Date: Tue, 23 Mar 2004 12:57:23 -0800

Marsh,

Can I use this in a query to update a field on a table?

Thanks.

Melinda
>-----Original Message-----
>Melinda wrote:
>
>>I need to be able to strip off the non numeric
characters
>>from a string. For example, in the string "12345ABC", I
>>need to strip off the "ABC" and be left with
>>only "12345".
>
>Dim strNum As String
>Dim K as Integer
>For K = 1 to Len(yourstring)
> If Mid(yourstring, K, 1) Like "*[!0-9]*" Then
> Exit function
> End If
> strNum = strNum & Mid(yourstring, K, 1)
>Next K
>
>
>--
>Marsh
>MVP [MS Access]
>.
>

Relevant Pages

  • Re: String Manipulation
    ... >Can I use this in a query to update a field on a table? ... >>>I need to be able to strip off the non numeric ... For example, in the string "12345ABC", I ... >>Dim strNum As String ...
    (microsoft.public.access.formscoding)
  • RE: Parameter from Form
    ... Melinda ... > Mybe you need to filter on a different column in the combo, ... > Good luck ... >> I have a query that uses a parameter on my form to update a combo box. ...
    (microsoft.public.access.queries)
  • Re: Use a number from last quarter
    ... The query I posted will return data across years. ... wanting quarter one to start at a particular time of the year (i.e. ... Jamie ... >> Hi Melinda, ...
    (microsoft.public.access.queries)
  • Re: Like Date Parameter
    ... be empty for the dates? ... One way to do this would be this criterion ... "Melinda" wrote in message ... > My query uses 8 other parameters that come from this form that use Like. ...
    (microsoft.public.access.queries)
  • RE: IsNull Parameter in Crosstab
    ... that was suprisingly easy and boy do I feel dumb. ... the datatype to Value, ... "Melinda" wrote: ... > I have a query that accepts multiple parameters. ...
    (microsoft.public.access.queries)