"#" for Dates; Equivalent for numbers or currency?
Posted on 2012-08-22
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?