Search results

Calculation This is excellant! sbenj69 its exactly what I needed.. I got the picture now by looking what you did with the queries and not trying to do it in the form. Thank you so much for your help, now that I have jumpted this obstacle I can continue. Thank you again!

The year will be always the previous so in 2009 it will be adding up the totals for 2008 etc. The key field is [Account] so the total should be grouped by account giving the total cash for that particular account for the given year.

Calculation... Thanks, sbenj69... Im trying to do something slight different I might of explained it wrong. Im attaching a small sample of the MDB so you can see what Im tring to acheive. When a record is displayed the field [Amount_Previous_yr] should display the total of amounts that were...

Can someone help me construct a formula in a form that I can incorporate into the control source in a field. The primary fields in my form that I need to evaluate for the formula are [Date], [Account] & [Amount]. I would like the field to add the sum of [Amount] for all [Account] numbers that...