Solved Wildcard Search Query : to Significant Figures (1 Viewer)

GUIDO22

Registered User.
Local time
Today, 16:24
Joined
Nov 2, 2003
Messages
515
I have a query that uses the following LIKE condition...

Code:
Like [Search for OD?] & "*"

This returns all items where the OD(Outer diameter of components) broadly matches the search criteria.
However, my stock of components has sizes : 16mm and also 160mm...

If my query search string is '16'... currently, I also get matches on sizes that are 160mm .. I dont want this..
I need the search to be specific to the number of significant figures as specified.... so a search for '16' returns all diameters of 16, 16.40, 16.65 etc

Thanks in advance for any help..
 

Minty

AWF VIP
Local time
Today, 16:24
Joined
Jul 26, 2013
Messages
10,354
You could use the INT() function to match values?

Something like
[Search for OD?] = Int([OD])
 

Users who are viewing this thread

Top Bottom