Criteria to filter a query Field

[IFORD]

I have a query field name stock and the field is a texted field and it can have in it:

5182
4943
tp203
t604

HOw do I make a criteria that will just pull the records that is a number like 5182 or 4943 ect.
When I made the database I did not take into acct for new and used vehicle put I can tell by the stock number if it is new or not.


Thanks for any help
irene

 

[PHV]

In the SQL view pane:
SELECT ...
FROM ...
WHERE Val([stock])=stock

or:
WHERE stock LIKE '#*'

or:
WHERE IsNumeric([stock])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[IFORD]

when i can and paste this in my sql
i get a characters found after end of squl statement and it highlights SELECT ...

IT HAS BE A LONG TIME SINCE I HAVE DONE ANY WORK WITH MY DATABASE QUERY.

 

[lespaul]

did you change the SQL and remove the ... and insert in an * or the field list and remove the ... after the FROM and add a table name?