Iamrickdeans
Registered User.
- Local time
- Today, 12:04
- Joined
- Apr 8, 2013
- Messages
- 29
Hi All,
So again thankyou, in advance for help given in regards to this query I will simplify as much as I can on my ongoing learnign of Access so my question is this.
I have a form lets call it 'Customer' and I have a table called orders how can I write 'Excel like' Countifs and sumifs formulas? I have been trying the IIf functions I believe correctly but am not getting the results expected or rather nothing at all!
What I am wanting to do is for example look at the table 'orders' and count all 'orders' which are for the 'Customer' in the active form this field is imaginatively called 'Customer Number' and 'orders' that are for simplicity 'rocks'
Basically if the client in the active form exists in the orders field count how many times they have placed an order for rocks.
Again thank you in advance.
Regards
Richard
So again thankyou, in advance for help given in regards to this query I will simplify as much as I can on my ongoing learnign of Access so my question is this.
I have a form lets call it 'Customer' and I have a table called orders how can I write 'Excel like' Countifs and sumifs formulas? I have been trying the IIf functions I believe correctly but am not getting the results expected or rather nothing at all!
What I am wanting to do is for example look at the table 'orders' and count all 'orders' which are for the 'Customer' in the active form this field is imaginatively called 'Customer Number' and 'orders' that are for simplicity 'rocks'
Basically if the client in the active form exists in the orders field count how many times they have placed an order for rocks.
Again thank you in advance.
Regards
Richard