Search results

Hello, I am having trouble with this formula not giving me the q2 results of last year. It still give me the current year results =DSum("[QTY]","[InspectionsT]","[TaskID]=3 And Datepart('q',Dateadd('yyyy', -1, [DateCompleted]))=2") Any help would be greatly appreciated

Hello, I am trying to add up records with the quantity of and then if the quantity is greater than 1 add that to the count. So the single record is counted as many times as the quantity says. If i have 12 records all with quantity 1 then that would be 12 and then if i had 1 record that had a...