I am not sure which I should use. I have a table that has three fields ID, Percent, Range, the id field is just that and automatic, the Percent field is 3%, 5% and 7%, the Range is <11, >10<21, and >21, now the purpose of this is because our contract says that if you buy less than 11 dogs you get 3% off of your purchase price, if you by between 11 to 20 dogs you get 5% off your purchase price, and if you buy 21 or more you get 7% off your purchase price. I know that I will have a form that tells me how many dogs are purchased and what the total price is. Have I set this up wrong to start with? I know that Access will do an if or if else and an if, then statements. I have never been successful with these nor do I know if they will help me with this problem. Can any one give me guidance. thank you