View Selection Criteria

Can someone tell me why this code doesn't work? I only want to show documents using form "Yieldsheet1" and only if fields "so" or "so2" have any values in them.

SELECT ((Form = "YieldSheet1")) & (!@Contains(so; "")) | ((Form = "YieldSheet1")) & (!@Contains(so2; ""))
schmad01Asked:
Who is Participating?
 
Sjef BosmanGroupware ConsultantCommented:
Trimming won't harm...

    SELECT Form = "YieldSheet1" & @Implode(@Trim(so:so2);"")!=""
0
 
p_parthaCommented:
SELECT (Form = "YieldSheet1") & ((so !="") |(so2 !=""))
0
 
Sjef BosmanGroupware ConsultantCommented:
SELECT Form = "YieldSheet1" & @Implode(so:so2;"")!=""
0
 
p_parthaCommented:
Bro
If you wud be kind enough to see my questoin also

Parhta
0
 
schmad01Author Commented:
Thanks, why didn't I think of that?   :- ]
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.