Formula in Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dallin - 31 Oct 2006 22:57 GMT

I'm trying to create a new column that includes everything from the right of
the * in the following number, what function/formula will do that for me?
Thanks.

1*1003
12*455556

Reply to this Message

Jeff Boyce - 31 Oct 2006 23:07 GMT

Check Access HELP for the syntax you'll use with the Mid() function and the
Instr() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP

> I'm trying to create a new column that includes everything from the right
> of
[quoted text clipped - 3 lines]
> 1*1003
> 12*455556

Reply to this Message

John Vinson - 01 Nov 2006 00:57 GMT

>I'm trying to create a new column that includes everything from the right of
>the * in the following number, what function/formula will do that for me?
>Thanks.
>
>1*1003
>12*455556

Well, this is obviously a Text field, not a number, since numbers
can't contain nonnumeric characters. Try

Mid([fieldname], InStr([fieldname], "*") + 1)

This will pop an error if the field does not contain an asterisk - let
us know if you need a getaround for that possibility.

John W. Vinson[MVP]

Reply to this Message