I have a Table A with column H.Date and Table B with columns E.Date and N.Date
Now, I want to see only values in Table A for which H.Date in Table A is between E.Date and N.Date in Table B. I can join Table A and Table B.
I can't seem to get a valid expression to achieve this while inserting a query calculation in the data module. Any help will be highly appreciated!