I have a report where I need to specify a data range in a running total and not sure how to write.
Need to pull all data < currentdate and also include currentdate items where entertime is less than 6:00am
Production pounds < currentdate = 20,000
currentdate records entered before 6:00am = 2000
I want to have a single statement that will capture the 22,000 total.