Formula in Query

[Guest]

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

 

[Jeff Boyce]

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

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]