Criteria

[KenHigg]

I'm having a brain freeze here... How do I return only rows where a fld has only 9 numerics. Like:

435565433
532535366
234234553
.
.
.

I want to eliminate stuff like:

EO Kit
NASI
Sidewall
.
.
.

Thanks for any hekp,
ken

 

[mresann]

Look at my post in this location. You can look at the code and modify it for your own use.


Phone Number formatting

 

[Ukraine82]

Try this....
If your letters come first use right function...

Right([fieldName],9)

If your numbers come first use the left function

Left([StockNumber],9)

hth,
Michael

 

[KenHigg]

Maybe I was unclear. I have this:

435565433
EO Kit
532535366
NASI
Sidewall
234234553
234353562
...

And I just need this:
435565433
532535366
234234553
234353562
...

I thought I could do something a little easier than a function...

Thanks for the code. I may end up using it...

Ken

 

[mresann]

This may work (in the WHERE clause of a QBE grid for the particular field):

If Len([fieldname]) = 9 And IsNumeric([fieldname])

 

[KenHigg]

That worked!

Thanks!
Ken

 

[razorking]

What's wrong with - like "#########"

 

[KenHigg]

I'll try it.

Thanks,
Ken