query to sum fields over a date range.

<Note that I’m querying on the End date – 1.>

why?

shouldn't it be   End date + 1

I want to exclude the last entry from the results.

if your date range is 8/1/2014 and 8/28/2014,
your criteria will be

between 8/1/2014 and 8/27/2014

you will exclude all records with date of 8/28/2014


be more specific about your criteria



.

SomeDT Between startDT and EndDT INCLUDES dates at both ends.  So it is the same as
SomeDT >= StartDT and SomeDT <= EndDT

If you want to exclude the EndDT, then use
SomeDT >= StartDT and SomeDT < EndDT
OR
SomeDT Between startDT and EndDT - 1

I didn't look at your attachment.  I can't download them here.  Your problem could be that your date includes time and that changes your criteria.  You can use the DateValue() function to pull out only the date part of a date/time field.

DateValue(SomeDT) Between startDT and EndDT

Pat, I'll use the < as you described.  Simpler. The date range works fine.  It is the summing of the netwtadded and netwtremoved fields that I need.  Sum the netwtadded field for the records between start date and end date.  Thanks,]
Brooks

ok., i'll leave the two of you..
you seems to be not interested to respond in my comment.

I apologize Rey.  That was not intended.  In my mind, the date range is not my problem.  It is the summing of the netwtadded and netwtremoved fields.  

The criteria should be all records from start date to < end date.

Rey, FYI - Between included dates at both ends of the range.

<Rey, FYI - Between included dates at both ends of the range. >

I know that long time ago.

I thought so but your previous answer indicated that Between excludes the end date.  If I misunderstood it, I apologize.

In the database I uploaded, the table is Data.  Using the criteria:
Equipment: 2-40-21-001
Date Range: 8/6/2014 to 8/14/2014

The selected records are:
Date Used             Operator              Net Wt Added             Net Wt Removed            Notes
8/6/2104                0326                         15                                      0              
8/10/2014              0326                         25                                      0        

I need the query to sum the Net Wt Added records.  And sum the Net Wt Removed records.  In the end I'll subtract the removed from the added and divide by the number of days.

Current query:
SELECT data.DateUsed, data.Operator, data.EquipmentNumber, data.EquipmentDescription, data.ChemicalName, data.NetAddedWT, data.NetRemovedWT, data.Notes
FROM data
WHERE ((data.[DateUsed]) >= [Forms]![Switchboard]![cboStartDate]) And ((data.[DateUsed]) < [Forms]![Switchboard]![cboEndDate]) AND ((data.[EquipmentNumber])='2-40-21-001')
ORDER BY data.[DateUsed];

I hope this helps.
Thanks,
Brooks

Perfect!  Thank you!
Brooks

Perfect!  Thank you!
Brooks

You are welcome!

/gustav