Hi guys! Hope this is the right forum.

My table called CASES holds all the cases we've done for clients this month. Here are two of the fields it has:

DATE_IN (date)

UNITS (calculation, it counts how many units were in the case)

Does anybody know a quick way for me to see how many units in total we received in April?

You say that UNITS is a calculation field, but what is it calculating? What is the result of the calculation? A Number?

A down and dirty way of getting there would be to add a summary field to display the SUM of UNITS. Then, simply do a find using the date field using "4/1/2010...4/30/2010" The summary should show a total based on the current found set.

What is the language you are currently using?.I also encountered that case before but using different data base.I use Microsoft access to create report,in that way i can easily edit and insert the code.