Formula in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
the * in the following number, what function/formula will do that for me?
Thanks.

1*1003
12*455556
Click to expand...

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]
 
Back
Top