### Calculate total just for today, not any other days

Posted:

**Thu Apr 15, 2010 10:45 am**Hello. I have created a simple database. Here is what I have so farâ€¦

Field 1: Date (time record added)

Field 2: User inputted integer (in my case, a number from 0 to 999)

Field 3: Calculated field that is a running total of Field 2

Ok, so far it works great. I get a running total that shows up in my form.

However, I would like the running total to only calculate the sum of field 2 for today (current Palm system date), not any other days. Is this possible?

Another acceptable option would be to calculate the total for the day of the last record added (which would be the current day) and this would have the same effect.

Or if neither option is possible, then choosing the date to be calculated via a user inputted date would be ok, although I really would like it to be automatic.

If anyone has a solution, could you reply with the actual formula? Here is what I have so far:

(P3+F2)|

Thanks in advance

Dan

Field 1: Date (time record added)

Field 2: User inputted integer (in my case, a number from 0 to 999)

Field 3: Calculated field that is a running total of Field 2

Ok, so far it works great. I get a running total that shows up in my form.

However, I would like the running total to only calculate the sum of field 2 for today (current Palm system date), not any other days. Is this possible?

Another acceptable option would be to calculate the total for the day of the last record added (which would be the current day) and this would have the same effect.

Or if neither option is possible, then choosing the date to be calculated via a user inputted date would be ok, although I really would like it to be automatic.

If anyone has a solution, could you reply with the actual formula? Here is what I have so far:

(P3+F2)|

Thanks in advance

Dan