How to Query Design criteria using "greater than/less than"

[shin_mitsugi]

So let's say I have a list of purchase orders and I want to create a custom query that will ask me


"Greater than $X". So that when I enter in $100, only the orders greater than $100 appear in the result.

What is the expression I must use in the "Criteria" row so that this works? For example, to search by city I would enter [Type a city]. I tried ">$100" but that doesn't work.

Thank you!

[June7]

Don't enter $100, enter 100.

What field has the numbers?

SELECT * FROM tablename WHERE City=[Type a city] AND Amount>=[Enter number];

However, I do not recommend popup input prompts in query. Too difficult to validate user input and results in a lot of frustration.

Use a form to input parameters and reference the controls on form. Review http://www.datapigtechnologies.com/f...tomfilter.html