Sir, how can i return a value in ms access textbox?
My code is =Sum(IIf([district]=2,1,0))
where for example in District Table
1 = new york
2 = hawaii
What i want to do is like this
=Sum(IIf([district]=(return the numerical value of text.caption),1 ,0)
for example: Text.caption = hawaii
this code should lead to the first code i have which is fixed...
How do i change my code sir into a versatile type of code...? Can you help me sir...?
Thank you very much...
My code is =Sum(IIf([district]=2,1,0))
where for example in District Table
1 = new york
2 = hawaii
What i want to do is like this
=Sum(IIf([district]=(return the numerical value of text.caption),1 ,0)
for example: Text.caption = hawaii
this code should lead to the first code i have which is fixed...
How do i change my code sir into a versatile type of code...? Can you help me sir...?
Thank you very much...