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
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