"#" 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?
BBluAsked:
Who is Participating?
 
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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
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.