I am making a simple select query. I want to compare 2 values and if one is bigger than the other, then I want my selection to be limited by that. The problem seems to be that one of the values is an expression so it won't let me compare it to the other. I know I could make an additional query that adds the where clause but was wondering if I can do this without doing that. Here's my SQL: SELECT tblMutualcustomers.Customer, tblMutualcustomers.AverageDaysBetweenPickups, Max(tblinvoiceorderlinemaketable.ShipDate) AS MaxOfShipDate, Date()-[maxofshipdate] AS Dayssincelastpickup, tblinvoiceorderlinemaketable.InvoiceLineItemRefFullName, "Computer Generated" AS RequestType FROM tblinvoiceorderlinemaketable RIGHT JOIN tblMutualcustomers ON tblinvoiceorderlinemaketable.CustomerRefFullName = tblMutualcustomers.Customer GROUP BY tblMutualcustomers.Customer, tblMutualcustomers.AverageDaysBetweenPickups, tblinvoiceorderlinemaketable.InvoiceLineItemRefFullName, "Computer Generated" HAVING (((tblinvoiceorderlinemaketable.InvoiceLineItemRefFullName) Like "Mutualallet Pickup")); I want records to show up where the expression [dayssincelastpickup]>=[tblMutualcustomers].[AverageDaysBetweenPickups] Thanks!