Hi. I have a table with a field that holds the value for customer points,they get a point for every penny spent in our store. The customer gets rewarded every 100,000 points. This value is also added to this field as points rewarded. The form I have for this has a field which totals the points earned. The problem being is that it also adds the 100,000 points redeemed that is in this field. In the query I added to the criteria field "not like 100000", now the query returns a total of 41, when with out the criteria I get back 1,832,587. The first record in this field is 41 points collected. For some reason it's not totaling the points.
I should point out that the information for this table comes through an ODBC driver which works with the software database and I don't have any input on how they store their data. Thanks for any input.

Don't need a reply, I figured it out myself.
Thanks anyway......