DSUM() with multi-criteria in single field

[pholness]

Hi! I have the following DSUM() code with multi-criteria, BUT I need to adjust it so that I can 1) filter for more than one criteria on [Shift Info] and 2) so that the criteria for [FR_Date] range works?

For Example: And [Shift Info] = 'Day' And [Shift Info] = 'Night' And [Shift Info] = 'Onboarding-Training'

DSum("[Duration]", "MainEventForceReports", "[Duration] <> 0 And [FR_Date] > #" & Me.Text1.Value & "# And [FR_Date] < #" & Me.Text2.Value & "# And [Workfront] = 'Planning 2016 Spring' And [Shift Info] = 'Day'")

Thanks in advance!

 

[Micron]

Your date range is "not working"? I don't see what's wrong with it if not. How about
DSum("[Duration]", "MainEventForceReports", "[Duration] <> 0 And [FR_Date] BETWEEN #" & Me.Text1 & "# And #" & Me.Text2 & "# And [Workfront] = 'Planning 2016 Spring' AND [Shift Info] IN('Day','Night','Onboarding-Training'))

If this is on a report, I'd let the report group footer or report footer handle the sum. You can also set a textbox source to the value returned by a totals query if it's on a form/report.
P.S. - you don't need .value - it is the default property for the control. Also, -'s in names is not good form.

 

[pholness]

Thanks! + Thanks for the info - you're correct. This solved the issue.

 

[pholness]

One more thing re: 'Not IN'

This seems to shoot an error: ...

[Workfront] = NOT IN('Planning 2016 Fall','Planning 2017 Spring') AND

...

Would you know why?

 

[pholness]

No worries stupid mistake onmy part please ignore.