Thank you for offering to help!
LTL: [getB]![LTL] + [getT]![MIN] + [getC]![MIN]
The above expression is in my query design.
I want to know if I can make it only add the tables that exit. This is because, all the above tables are made through other queries. Some queries run under some conditions, etc.
So I want to know that using an 'iif' statement I can check if a table exists then add them? (only add fields from tables that exists)
I want to know if its possible if then how?
- The solution I have in mind is far complicated. That is, call a function for each table within expression builder
Eg: iff (FUNCTION1() = "true"; iif(function2() = "true", iff (function3() ="true",[getB]![LTL] + [getT]![MIN] + [getC]![MIN]), [getB]![LTL]), [getB]![LTL] + [getT]![MIN]),[getT]![MIN]
+ [getC]![MIN] )
...gah this is complicated...I dont think above a possible code :(