Search results

Hello, I need to clean up data from text file which is huge. I wonder if Access Expression Builder can mirroring "IF function" from Excel Here is what i am trying to do The data consist of multiple customer and multiple date. But the layout only specified customer ID once eg. CustID : aaaa...

Uups.. i asked in the wrong category. Now move the question to the right one I hope:) i am a novice in ms access so really need help Wonder if i can have a count if function inside the iif function. In excel i will create a formula like this =if(countif($a$1:$a$100,a1)=1,a1,"")) Is there...

Hello, i am a novice in ms access so really need help :) Wonder if i can have a count if function inside the iif function. In excel i will create a formula like this =if(countif($a$1:$a$100,a1)=1,a1,"")) Is there anyway that i can create that kind of formula in query criteria? Thanks in...