Reply to thread

Message: [QUOTE="Marshall Barton, post: 13500741"] I am still not clear on exactly what you what you want it to do, but see if this is close: SELECT RepairInformation.ID, Year(RepairInformation.[DATE SERVICE CLAIM FILED]) AS [DATE SERVICE CLAIM FILED By Year], OptionPeriods.BeginDate, OptionPeriods.EndDate, Sum(RepairInformation.COST) AS SumOfCOST FROM RepairInformation INNER JOIN OptionPeriods ON RepairInformation.ID = OptionPeriods.ID WHERE OptionPeriods.BeginDate >= Forms![Monthly Project Cost Report]!BeginDate AND OptionPeriods.EndDate<=Forms![Monthly Project Cost Report]!EndDate GROUP BY RepairInformation.ID, Year(RepairInformation.[DATE SERVICE CLAIM FILED]) Stay in SQL View, do not switch back to query design view. If you get an error, post back with the exact message and what in the query is highlighted. If/when the query runs cleanly, explain what about the result is not what you are hoping to get. [/QUOTE]