Testing for a literal or a number

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

Guest

I have a table that has codes like C345, B34B, C34A, and so on.
The last character is significant in that he identifes the plant location
that a part was produced.
I have done a query adding a column called LastChar using the Right function
to segregate the last character from the part number. My results are 5, B,
A, and so on.
What I would like to be able to do is add another column to the query called
TextorNumber that tests the items in the LastChar column and if it is a
number I want the letter X to appear. If it is not a number I want the value
from LastChar to appear.
Thanks for any help.
 
Why not just use IsNumeric()?

IIf(IsNumeric([LastChar]), "X", [LastChar])

JJ
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Curve fitting with weighted trendline 1
Like numbers in a field 3
Problem with capitalized letters showing up lower case in a report 2
text to column in Access 4
Removing numbers (or non alphabetical numbers from a field) 5
Select A Character In A Part # 1
Tweaking a calculated field in a query 4
InputBox within a query 4

Back
Top