I am trying to replicate a Access Query that contains a HAVING statement. This query requires a join between two tables which I have replicated on datameer on Sheet_A, then I have created Sheet_B where I groupby my required columns sourcing Sheet_A.
I am confused on where to implement the HAVING statement, either on Sheet_A or Sheet_B, the statement is as follows;
HAVING (((IIf([Sheet_A]![ID] Is Null,[Sheet_A4]![ID],[Sheet_A]![ID])) Is Not Null));
Do I use Advanced Filters on Sheet_A or Sheet_B?
Please sign in to leave a comment.