Calculating: how many units did we sell this month?

[Charlie Kilo]

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?

[Jeff M]

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.

[internet_guru33]

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.