Reply to thread

Message: [QUOTE="Marshall Barton, post: 13497474"] I don't think I quite follow all the stuff in your query, but the one thing that jumps out as very strange is the conditions on the Sum(Cost). You are trying to compare the total cost to text strings, which makes no sense. I think you should remove those two criteria. It's also seems likely that you should get rid of the Min and Max of OptionPeriods.BeginDate. Try changing your HAVING clause: HAVING (((Min(OptionPeriods.BeginDate))>=[Forms]![Monthly Project Cost Report]![BeginDate]) AND ((Max(OptionPeriods.EndDate))<=[Forms]![Monthly Project Cost Report]![EndDate]) AND ((Sum(RepairInformation.COST))>="BeginDate" And (Sum(RepairInformation.COST))<="EndDate")) to: WHERE BeginDate>=Forms![Monthly Project Cost Report]!BeginDate AND EndDate<=Forms![Monthly Project Cost Report]!EndDate [/QUOTE]