Looking up 2 differnt Criteria

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!!!
 
M

Mike

From your description it sounds like you have ">" in the field for your
dollar amout, as well as ">" in the number of time used field. With this
query your results will only show records that are over $350 and more than 10
times used. If both conditions are not met, the query returns no records. You
may want to try "<" in the field for your dollar amout and ">" in the number
of time used field. With this query your results will show records that are
under $350 and more than 10 times used.
 
T

Tom Wickerath

In the query design grid, you will need to enter these two criteria on
*different* lines, in order to get an OR'd result. If you enter the criteria
on the same line, you will have asked Access to return an ANDed result (ie.
number of times used greater than 10 AND amount greater than $350).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top