I have the following If..Else statement. Now, I would like to build the individual sections based on user criteria.
I would like to know if it is possible to save thes sections as strings and add them to the if else statement.
I have tried the same for Select...Where statement by building WHERE , but I am not able to figure out how to put these sections between the If....Then
If ((rs_cluster1!Field31_2 = rs_cluster1_002!Field31_2) And (rs_cluster1!Field35 = rs_cluster1_002!Field35) And ((rs_cluster1!Field36 >= (rs_cluster1_002!Field36 - 5) And rs_cluster1!Field36 <= (rs_cluster1_002!Field36 + 5) And (rs_cluster1!Field41 = rs_cluster1_002!Field41) And (rs_cluster1!Field58 = rs_cluster1_002!Field58) And (rs_cluster1!Field61 = rs_cluster1_002!Field61) And (rs_cluster1!Field62 >= (rs_cluster1_002!Field62 - 10) And rs_cluster1![Field62] <= (rs_cluster1_002![Field62] + 10)) And (rs_cluster1!Field97 = rs_cluster1_002!Field97) And (rs_cluster1!Field108 = rs_cluster1_002!Field108)) _
And (rs_cluster1!Field110 >= (rs_cluster1_002!Field110 - 5) And (rs_cluster1!Field110 <= (rs_cluster1_002!Field110 + 5)) And (rs_cluster1!Field117_2 >= (rs_cluster1_002!Field117_2 - 5) And rs_cluster1!Field117_2 <= (rs_cluster1_002!Field117_2 + 5)) And (rs_cluster1!Field145_2 = rs_cluster1_002!Field145_2)))) Then
I would like to know if it is possible to save thes sections as strings and add them to the if else statement.
I have tried the same for Select...Where statement by building WHERE , but I am not able to figure out how to put these sections between the If....Then
If ((rs_cluster1!Field31_2 = rs_cluster1_002!Field31_2) And (rs_cluster1!Field35 = rs_cluster1_002!Field35) And ((rs_cluster1!Field36 >= (rs_cluster1_002!Field36 - 5) And rs_cluster1!Field36 <= (rs_cluster1_002!Field36 + 5) And (rs_cluster1!Field41 = rs_cluster1_002!Field41) And (rs_cluster1!Field58 = rs_cluster1_002!Field58) And (rs_cluster1!Field61 = rs_cluster1_002!Field61) And (rs_cluster1!Field62 >= (rs_cluster1_002!Field62 - 10) And rs_cluster1![Field62] <= (rs_cluster1_002![Field62] + 10)) And (rs_cluster1!Field97 = rs_cluster1_002!Field97) And (rs_cluster1!Field108 = rs_cluster1_002!Field108)) _
And (rs_cluster1!Field110 >= (rs_cluster1_002!Field110 - 5) And (rs_cluster1!Field110 <= (rs_cluster1_002!Field110 + 5)) And (rs_cluster1!Field117_2 >= (rs_cluster1_002!Field117_2 - 5) And rs_cluster1!Field117_2 <= (rs_cluster1_002!Field117_2 + 5)) And (rs_cluster1!Field145_2 = rs_cluster1_002!Field145_2)))) Then