I'm not sure what exactly you want to do here. Do you want to call specific data and then only show that data? If that data is not available do you want to show all the data?
Please be more specific, and I'm sure we can help here.
AndreRet
Senior Poster
3,922 posts since Jan 2008
Reputation Points: 334
Solved Threads: 350
simple code
if a=a or b=b or c=c and d=d then f=f
'or
if a=a or b=b or c=c and d=d then
f=f
end if
or more
if a=a or b=b or c=c and d=d then
f=f
else
f=g
end if
or more
if a=a or b=b or c=c and d=d then
f=f
elseif c=c and d=d then
f=h
elseif d=d then
f=i
else
f=g
end if
omoridi
Junior Poster in Training
72 posts since Sep 2009
Reputation Points: 10
Solved Threads: 10
i donot know what u want exacly but if vb have iif maybe it work for u
a=iif(b=c,d,f)
this syntax like thsi
if b=c then
a=d
else
a=f
end if
omoridi
Junior Poster in Training
72 posts since Sep 2009
Reputation Points: 10
Solved Threads: 10
maybe you wnat to some this like "case"?
select case a
case 1
b="a1"
case 2
b="a2"
case 3
b="a3"
case is>3 and is<10
b="a4-9"
case else
b="a>=10"
end select
omoridi
Junior Poster in Training
72 posts since Sep 2009
Reputation Points: 10
Solved Threads: 10
omoridi
Junior Poster in Training
72 posts since Sep 2009
Reputation Points: 10
Solved Threads: 10
omoridi
Junior Poster in Training
72 posts since Sep 2009
Reputation Points: 10
Solved Threads: 10
@Katherine, the reason why you are not getting any feedback is because you have hijacked someone else's thread. Your question does not even have any reference to the original question!
Please open your OWN thread and I promise we will try and help.
@Omiridi, please do not submit any replies on hijacked threads. Rather let the member open their own post, thanks.
AndreRet
Senior Poster
3,922 posts since Jan 2008
Reputation Points: 334
Solved Threads: 350