wildcard decimals

[iuphim]

I have a list of numbers both whole and decimal numbers. I want to do a search for all decimal numbers. What should I use?

Example:

123
123.23

I want to find anything with "#.#" - like 123.23 in the above example.

Thanks

 

[Atomic Shrimp]

Have you already imported the list into Access? If so, what type is the field in which the values are stored?

If it's a text field, you can run a query against it and put the following in the criteria:
Like "*.*"

If it's numeric (double) field, you could put this in the criteria:
<> Int([YourFieldName])

 

[namliam]

Couple of ways...

If you use the INT function you can trim of any decimals... Thus if INT(Yournumber) does not equal YourNumber it contains a Decimal

Alternatively you can do Int(YourNumber) - YourNumber and anything not equeal to 0 will contain decimals....

Or... You can use Format(YourNumber, "0.00") to turn the number into a string, so you can use your Like... or "Not Like" function

 

[iuphim]

both work!

thanks for the quick response.