2 Differnt Parameter

M

Mr. Damon

I'm trying to write a query that will allow me to look up the dollar amount
greater than $350 or the Number times used greater that 10. Right now for the
Amount i have ">" Amount but when I do ">"Number time used, it doesn’t show
me the record for when it less than $350 but Greater than 10. I'm trying to
get it to show me the record where if the Amount isn’t >350 it should still
be able to show me the number times used >10. HELP!!!
 
K

KARL DEWEY

or the Number times used greater that 10.
I do not understand your phrasing. Post sample data with expected results.

Also post the SQL of your query. Open query in design view, click on menu
VIEW - SQL View, highlight all in the SQL window, copy, and paste in a post.
 
Top