Use a query to find a currency amount

Experts, I am surprised this is as difficult as it is. I have made a qry with the following as  a criteria:
Like [Enter The Amount to Find] & *

I enter the amount such as 150 (expecting to find an amount such as $150,000,000.00) but it returns nothing.

what is wrong?  thanks
PetrobrasAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
does this work any better:
Like "*" & [Enter The Amount to Find] & "*"

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.