<div>
Give this a try for your where statement<br />
<br />

<pre><code id="code-20-41016078-1">Where T1.DATE1=T2.DATE1 and 
((T1.AMOUNT = ABS(T2.AMOUNT_1))  OR (T1.AMOUNT = ABS(T2.AMOUNT_2)))
and NOT T2.AMOUNT_1 Is Null and NOT T2.AMOUNT_2 Is Null</code></pre>
</div>


Give this a try for your where statement



Where T1.DATE1=T2.DATE1 and 
((T1.AMOUNT = ABS(T2.AMOUNT_1))  OR (T1.AMOUNT = ABS(T2.AMOUNT_2)))
and NOT T2.AMOUNT_1 Is Null and NOT T2.AMOUNT_2 Is Null

<div>
Sorry didn't understood the comment.......
</div>


Sorry didn't understood the comment.......

<div>
Yes, worked, thank you very much !
</div>


<div>
Accurate and fast - thank you !
</div>


<div>
<div class="content wysiwyg-content">
In MS-ACCESS I have two tables, say T1 and T2, both of them with fields T1.Customer_No, T1.AMOUNT, T1.TRADE_ID and T1.DATE1 fields and T2.Customer_No, T2.AMOUNT_1, T2.AMOUNT_2 and T2.DATE1.<br />
I need to select all rows from T1 where :<br />
<br />
T1.AMOUNT = ABS(T2.AMOUNT_1) *OR* T1.AMOUNT = ABS(T2.AMOUNT_2)<br />
and additionally<br />
T1.DATE1 = T2.DATE1<br />
<br />
Constraint: if T2.AMOUNT_1 is null or T2.AMOUNT_2 is null, then I don't want any comparison (excluded records).<br />
<br />
(No I can't join customer ids)<br />
Any help appreciated.
</div>
</div>


In MS-ACCESS I have two tables, say T1 and T2, both of them with fields T1.Customer_No, T1.AMOUNT, T1.TRADE_ID and T1.DATE1 fields and T2.Customer_No, T2.AMOUNT_1, T2.AMOUNT_2 and T2.DATE1.
I need to select all rows from T1 where :

T1.AMOUNT = ABS(T2.AMOUNT_1) *OR* T1.AMOUNT = ABS(T2.AMOUNT_2)
and additionally
T1.DATE1 = T2.DATE1

Constraint: if T2.AMOUNT_1 is null or T2.AMOUNT_2 is null, then I don't want any comparison (excluded records).

(No I can't join customer ids)
Any help appreciated.

MS-ACCESS conditional SELECT

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.