kholm
04-22-2002, 07:11 AM
For a query, I need to weed out those who have a percentage more than 100%. I tried putting >100 in the criteria, but it returns nothing. What am I doing wrong?
|
View Full Version : Criteria Percentage kholm 04-22-2002, 07:11 AM For a query, I need to weed out those who have a percentage more than 100%. I tried putting >100 in the criteria, but it returns nothing. What am I doing wrong? David R 04-22-2002, 07:23 AM If it's a percentage field, it might be >1 (100% = 1 whole) kholm 04-22-2002, 08:19 AM Yes! Thank you, it was so simple and it worked! |