Filtering for numeric value

[Bear]

Sorry RuralGuy, I first put in "VBA help" and got the same ole stuff I had been looking through. I then tried "IsNumeric() and guess what - I had already seen it too.

You know what? I used to teach eighth grade Math (and Plane Geometry). I used to tell my students that if going in through the front door could not solve a problem than maybe you needed to go in through the back door or through a window. Let me apply that theory now. You seem to be knowledgeable and if you will bear with me for a few seconds I will explain exactly what I am doing and maybe you can tell me where I am going wrong.



I am using the Query Wizard. I get to the point where it asks if I want to Open the Query or Modify the query and I click Modify.

The top row in the first column in the chart says"Title" and in the fourth row in this column the box is checked. In the top row of the second column I enter "Left([Title],1)", and in the criteria box in this column I enter "A" (in quotes). This will give me all of the movie titles that begin with the letter A. No problem so far.

The problem starts when I try to get the movie titles that are numbers or start with numbers. I have tried to plug in many different words and groups or variations of words in this criteria box to no avail. (including: Number, Numeric, IsNumeric, IsNumeric(), IsNumeric( ), etc....)

Should I be plugging in these "experiments" in this method? Should I be adding something else? Is my syntax wrong? Should I be using some other method? If so, what?

I'm going crazy, crazy, crazy, crazy...

Sorry, I'm okay now.

[Bear]

In a code module type IsNumeric() and highlight it and then hit F1 and see if it will get you there.

OOOOOOOoooooo!!! That sounds good!

What is a code module?

[RuralGuy]

Open the query in design view without the wizard. Any query will do here. Switch to SQL view and copy and paste that into a post.

[Bear]

I was confused by Orange when he posted

You could try a query such as

Select * from yourTable
where
Left(Title,1) In ("1","2","3","4","5","6","7","8","9","0")

but it gave me an idea.

I tried putting"1","2","3","4","5","6","7","8","9","0"
into the criteria box and was told that I had used a comma incorrectly. So I thought back to my old college BASIC programming class (don't get any ideas about how this should have helped me with my current problem - this was back in 1979 before Access) and tried the word "or".

I put "1"or"2"or"3"or"4"or"5"or"6"or"7"or"8"or"9"or" 0" into the criteria box and WHAM-BAMMA-LAMMA it worked. I knew there had to be a simple solution. I just didn't think it would be that simple.

I really appreciate everyone's help - specially RuralGuy. I kept feeling guilty that I was tying up your Sunday and kept visualizing you turning to someone and saying, "Wow, what an idiot."

Anywho, my index is now complete and I can start worrying about some other inane asinine problem. I will go right now and mark this "solved"

Thanks again!

[Bear]

Oh, P.S.

I learned some new things from ya'll.

Thanks for that too!

[RuralGuy]

Beautiful! Glad you got it sorted.

[orange]

Bear,
Review this link
http://www.techonthenet.com/sql/in.php
and you'll get a lesson on a Select query with an IN statement.
Good luck.