countif in form

[balahawy]

i have access table inculded 2 column , each column inculde 3 words(false, right, 5%)
i have a form show this items in dropdown list and i want to
count false from the 2 column once thee user choose it from the dropdown list
count right from the 2 column once thee user choose it from the dropdown list

sum 5% from the 2 column once thee user choose it from the dropdown list


all that in same form

 

[pr2-eugin]

Why the need to start another thread, when you already have one opened (countif)?

 

[balahawy]

because i can't understood from the previous advisor maybe I’m the reason so started new one and explain in details my problem

 

[pr2-eugin]

The previous adviser was me ! We need to see what is the data you are dealing with. On the other thread, I have attached some links to help you ask questions properly.

 

[balahawy]

so i can't understood what do you mean with what kind of data i deal with

 

[pr2-eugin]

Example of my data in my table,

noteID    agentID    noteDate      notesMsg
-------+----------+--------------+-------------------
1           1        01/05/2014    If you are not going to help. 
2           1        02/05/2014    I am unable to help you !
3           2        03/05/2014    Just give some sample data; like this.
4           5        04/05/2014    Probably a result what you are expecting to see.

 

[balahawy]

Agent -----Communicate------ Listenin -----Validation_KYC
-------- ---------- ------ --------------
Abdo Mamdouh --Fetal --------5%-- -----------Non Fetal
Abdo Mamdouh-- 5%-----------5%---------- Non Fetal
Mohamed --------Fetal Non---- Fetal ---------5%


so i want to count the fetal and non fetal and sum the 5 % per row