Recent content by Valient

Thank you very much

Hi AW Team, Good day. I would like to ask your assistance again regarding the code. In the FORM under DATA , CONTROL SOURCE, I use the below code to get the quotient value of T1 and T2 =[T1]/[T2] It works fine as per the code if both T1 and T2 has number value. However, If the value is "N/A"...

Thank you very much. Solved

Hi AW Team, Good day. I would like to ask your assistance again regarding the code. In the FORM under DATA , CONTROL SOURCE, I use the below code to sum the number of "Closed" value in "Status" =Sum(IIf([Status]="Closed",1,0)) It works fine as per the code. However, I want to improve the code...

Thank you all for your valuable suggestions.

This one doesnt work: =iif(Count([ProductA])=0, "N/A", Count([ProductA])) This works: =IIf(Count([ProductA])=0, "N/A", Count([ProductA])) Also, I'm not an expert to this access field. The DB is created by an expert guy and there is no more support. I'm just adding more function and thanks to...

Thank you. I tried the code but it pop up with missing symbol, however when I change the "iif" to "IIf" it works. =IIf(Count([ProductA])=0, "N/A", Count([ProductA]))

Hi plog, You are right, I did the code in report. I tried the suggested code but it display the word "%NAMES" not the target "N/A"

The system doesnt allow me to attached the screenshot

Thanks for the response. I put the code in Control Source, Under Data.

Hi Team, Can you please help me. I'm using the code : =Count([ProductA]) To count all ProductA. However, when there is no ProductA in the list it display zero (0). Can someone help me to improve my code to display N/A instead of zero when no ProductA available

Hi AW Team, I would like to ask your help on how i can create a button that can search for the word like how google search works. I created a form call "form1" and I link to the "table1". Then make it a split form. On the Split form I added "unbound" and button and "Clear". What I want to...

Thank you very much. solved

hi, im sorry to open this topic again. The attached DB is working really fine. As shown, up to letter D (Figure1), it display the specific ID. But when it reached the letter E (Figure 2), all the values that I put from letter E to H does not display.. It always display as blank page. Could...

Thank you arnelgp, got it