SUM A FIELD If Another Condtion is met?

jimmy.guilfoyle

Registered User.
Local time
Today, 12:59
Joined
Jul 23, 2009
Messages
11
Hi Boys n Girls

I have tried Access help, Office online, This forum, the web for what Im trying to achieve.

Its very simple and yes I cant do it :-(

I have a form. On this form I want an expression that will sum if another condition is met. (all data from the same tble/source)

I have a field called invoicing amount and another field called actual or planned

So the table would be something like -

invoicing ammount actual or planned
500 actual
100 planned
200 actual

I have been trying to create an expression that will sum up invoicing ammount where a condition is met e.g actual

So my expression result based on the above simplified example would be 700 (as these are both actual)

Can anyone give me a tip on where I'm going wrong?

Appreciate any help.

Thanks

Jimmy
 
Go back to Access help and look up the GROUP BY statement. Everything that you need should be able to be found there.
 
Since you're conversant with the help files, have a look at the DSUM function.
 

Users who are viewing this thread

Back
Top Bottom