Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

"#" for Dates; Equivalent for numbers or currency?

I have a query that pulls thousands of transaction records.  I'm trying to restrict the set to values below a certain threshold, say $10,000.  when I hard code it (ie. under filter put <=10000) it works.  But when I try to add a criteria parameter (ie. <=[ceiling]), it produces incorrect results.

I'm guessing I need to put something around the brackets that tells Access I'm looking for a number or currency, like using the "#" sign with dates.

Does anyone know what character I should use or, if I'm approaching it incorrectly, a better way to do it?
0
BBlu
Asked:
BBlu
  • 3
  • 2
1 Solution
 
mbizupCommented:
Numeric criteria use no delimiters.

How are you entering your criteria, and what are the incorrect results?  

You could try this:

<= Val([Ceiling])
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In Access, numbers / currency do not require anything for delimeters, such as #'s for dates and "s for text.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>that tells Access I'm looking for a number or currency,
Access will evaluate it based on whatever the textbox's Forat property is.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
er, I mean Format.
0
 
BBluAuthor Commented:
Perfect!
0
 
BBluAuthor Commented:
Sorry..need some additional color around "Perfect".  The Val() function worked.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

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