on 07102007 5:39 AM
I have 2 columns A and B in the report:
A B C

1234 1234 1234
5903 0 5903
0 3287 3287
I want to get the column C.
So, the condition for the column C would be :
if A<>0 and B <>0 then A
else if A==0 then B
else if B==0 then A
I heared that this can be done by routines . I need the code to do this . Also let me know where to put the code.
This is urgent pls.
Vaishali
((A<>0)(B<>0)A)(A=0)*B(B=0)*A
Hopefully this will help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Nag. That made my task simple.:)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'll try after the users stop using the report. will update you on this...
so u sure, no need of routines for this ??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vaishali,
This is a simple formula which can be written in the new formula of the query.
For column C, you just create a New Formula and use write the formula as given by our friend in the above post.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User  Count 

95  
7  
7  
7  
4  
4  
4  
4  
4  
4 
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.