B
BlueWolverine
Hello
Ms Access 2003 on XP Pro.
I want to put an if statement in my where clause.
where
if Checkbox = true then
t.A=f.A AND t.b=f.b
else
t.A=f.A OR t.b=f.b
endif
1) Does this work?
2) Is this more efficient than having the vba pick between two different
queries?
Since I want to do this to two daisy chained queries, I would actually have
to write four queries for the vba method above. Don't want to do that.
Thanks.
Ms Access 2003 on XP Pro.
I want to put an if statement in my where clause.
where
if Checkbox = true then
t.A=f.A AND t.b=f.b
else
t.A=f.A OR t.b=f.b
endif
1) Does this work?
2) Is this more efficient than having the vba pick between two different
queries?
Since I want to do this to two daisy chained queries, I would actually have
to write four queries for the vba method above. Don't want to do that.
Thanks.