• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

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
0
Petrobras
Asked:
Petrobras
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
does this work any better:
Like "*" & [Enter The Amount to Find] & "*"

Open in new window

0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now