I need a query that will sum the netwtadded and netwtremoved fields over a data range. The query will be used for a report.
Use the equipment number 2-40-21-001.
Start date: 8/6/2014
End date: 8/14/2014
The query I’ve been using is: qry_rptEqDateRange
Note that I’m querying on the End date – 1.
I've attached the database.