Formula for showing numbers

[SMB]

We have clients that I need to show their case numbers. Most of them are numbers from 0-9. Some are alphabet. I would like for the numbers only to show. Is there a formula for that?

[JoeM]

Check out this link: http://support.microsoft.com/kb/210537

[SMB]

Check out this link: http://support.microsoft.com/kb/210537

I think i might have put this question out there wrong. I am creating a new query. In the criteria field, i am looking for a command to eliminate the alpha letters.

[JoeM]

What you put in the Criteria field selects which records to return, it doesn't "change" the value of what is shown.
If you want to "drop" the letters and show just the numbers, you would use a Calculated field in your query.

Or are you saying that entries are either "all numbers" or "all letters", and you just want to show the ones that are "all numbers"?
If that is the case, create a calculated field like this:

IsNumeric([MyField])

and place TRUE in the Criteria of this field. You can even elect not to show this field in your query results.

If that does not answer your question, some real examples of what you have in this field, and what you would like to see may help clarify your question.

[SMB]

Thanks. Yes either they are all numbers or all letters. Only want the numbers to show. Thanks

[JoeM]

OK. So did the second part of my previous response work for you when you tried it?

[SMB]

No it did not. I get no info. This is all new to me so I apologize if my questions are not right. I put the IsNumeric([with my field name here]) and I don't get any info

[JoeM]

Where did you put it?
Do you know how to create a Calculated Field in Access? See here: http://www.fontstuff.com/access/acctut02.htm

You would put that IsNumeric([FieldName]) part on the Field line, and you would put True on the Criteria row of that calculated field.

[SMB]

Ahh. That is what I missed was the Field line. I was putting it in the Criteria. Thank you