I have a query that is supposed to find Marital Status in a table then between lower and upper limits and return lower limit, else 0. It is returning all the records. The query is QryFedTax1, pulling data from QryFedTax. I know there as some fields that can be removed form QryFedTax but I don't want to remove them until I find I don't need them for the calculations. Can any see why it is not just pulling the record I request. DB attached.