Using DSum in a query field expression. I know the criteria in the DSum function can be tricky, having trouble getting this to work.
I have the following query expression:
OH Cost: DSum("[Total OH]","WeeklyCost","[Week]>="&Str([TrnsplWk])&" And [Week]<"&Str([RdyWk])"")
[Week] and [Total OH] are the columns in the WeeklyCost table (this table is not part of the query join).
[TrnsplWk] and [RdyWk] are fields in query
Trying to sum [Total OH] where [Week] is greater than or equal to [TrnsplWk] and less than [RdyWk].