<div>
Please try this like this ..Added GROUP BY and Having clause.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42380590-1"><span>SELECT Transaction_ID</span>
<span>FROM AccountsTransactions</span>
<span>WHERE Invoice IN (106263,106262,106367,106367) </span>
<span>GROUP BY Transaction_ID</span>
<span>HAVING SUM(Amount) = 2388.60</span>
</code></pre>
</div>


<div>
I don't get any errors but the query should return 2 Transactions_ID and it's not returning anything.
</div>


<div>
Can you please give me output of this -<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42380613-1"><span>SELECT Transaction_ID , SUM(Amount) amt </span>
<span>FROM AccountsTransactions</span>
<span>WHERE Invoice IN (106263,106262,106367,106367) </span>
<span>GROUP BY Transaction_ID </span>
</code></pre>
</div>


<div>
There is 1 transaction for 1,390.60 and 1 for 998.00
</div>


<div>
HAVING SUM(Amount) = 2388.60<br />
<br />
so because of above it did not return anything.<br />
<br />
is this amount - 2388.60 for single transaction ?
</div>


<div>
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) <br />
GROUP BY Transaction_ID <br />
<br />
Where do you enter the amount you are looking for?
</div>


<div>
We can do one of these below <br />
<br />
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) <br />
GROUP BY Transaction_ID <br />
HAVING SUM(Amount) = someValue<br />
<br />
OR <br />
<br />
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) &nbsp;AND Amount = someValue<br />
GROUP BY Transaction_ID
</div>


<div>
No there is more than 1 transaction that equals 2388.60
</div>


<div>
can you please give me output of this - ( copy paste - do not change anything. )<br />
<br />
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) <br />
GROUP BY Transaction_ID
</div>


<div>
I think there is some decimal issue is there.<br />
<br />
Do we have any values from 2388.60.. like 2388.6000002.. ??<br />
<br />
Please try like this also..<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42380643-1"><span>SELECT Transaction_ID , SUM(Amount) amt </span>
<span>FROM AccountsTransactions</span>
<span>WHERE Invoice IN (106263,106262,106367,106367) </span>
<span>GROUP BY Transaction_ID</span>
<span>HAVING SUM(Amount) &gt;= 2388 AND SUM(Amount) &lt; 2389</span>
</code></pre>
</div>


<div>
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) <br />
GROUP BY Transaction_ID <br />
HAVING SUM(Amount) = 2388.6<br />
<br />
RTURNS NO RECORDS
</div>


<div>
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67)  AND Amount = 2388.6<br />
GROUP BY Transaction_ID <br />
<br />
RETURNS NO RECORDS
</div>


<div>
Can you please give me output of below ?? <br />
<br />
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) <br />
GROUP BY Transaction_ID
</div>


<div>
The amount we are looking for is 2388.60 &nbsp;I've tried 2388.60 &nbsp;and 2388.6
</div>


<div>
Data Please ??<br />
<br />
Hv u tried below -<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42380676-1"><span>SELECT Transaction_ID , SUM(Amount) amt </span>
<span>FROM AccountsTransactions</span>
<span>WHERE Invoice IN (106263,106262,106367,106367) </span>
<span>GROUP BY Transaction_ID</span>
<span>HAVING SUM(Amount) &gt;= 2388 AND SUM(Amount) &lt; 2389</span>
</code></pre>
</div>


<div>
When I run the query below in Microsoft SQL Server Management Studio<br />
<br />
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) <br />
GROUP BY Transaction_ID <br />
<br />
<br />
The results is the Headers<br />
Transaction_ID and amt<br />
but no data
</div>


<div>
Please run below -<br />
<br />
SELECT * FROM AccountsTransactions<br />
<br />
and copy all the data with headers into excel and attach. I will check for you.
</div>


<div>
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) <br />
GROUP BY Transaction_ID<br />
HAVING SUM(Amount) &gt;= 2388 AND SUM(Amount) &lt;&nbsp;2389<br />
<br />
SAME THING HEADERS ONLY
</div>


<div>
See image file attached<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w47/1212452/Query-2017-11-24_11-24-58.jpg" target="_blank" class="file-inline" title="Query-2017-11-24_11-24-58.jpg (64 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Query-2017-11-24_11-24-58.jpg</a>
</div>


Query-2017-11-24_11-24-58.jpg

<div>
You are doing 1390.60 + 998 ?? This is incorrect as their Transaction_IDs are different --- &gt;<b> 198188 , 198189 </b> so the sum will not happen.<br />
<br />
Below will work without any issues.<br />
<br />
SELECT Transaction_ID , SUM(Amount) amt <br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) <br />
GROUP BY Transaction_ID<br />
HAVING SUM(Amount) = <b>1390.60</b>
</div>


<div>
The query will have to sum the amounts and give me the Transaction_ID of the ones that totals the requested amount.<br />
<br />
When the query is run I will not know what the lowest or highest amount is.
</div>


<div>
There could be 30 or 40 transactions and it might take 6 or 7 to make up the amount requested.
</div>


<div>
welcome. glad to help as always.
</div>


<div>
<div class="content wysiwyg-content">
Issue:<br />
A person has several invoice that may have one or more transactions in a Transaction file.<br />
What I need to do is get the transactions ID where some of the transactions equal a specified amount.<br />
<br />
Sample Transaction Table Fields<br />
<br />
Transaction_ID<br />
TranDate<br />
InvoiceNo<br />
Amount<br />
<br />
The query below would give me what I need <b>IF IT WOULD ONLY WORK<br />
<br />
</b>SELECT Transaction_ID<br />
FROM AccountsTransactions<br />
WHERE Invoice IN (106263,106262,106367,1063<wbr />67) AND<br />
SUM(Amount) = 2388.60<br />
<br />
PLEASE HELP I NEED TO GET THE Transaction_ID of those transaction where the sum = 2388.60
</div>
</div>


Issue:
A person has several invoice that may have one or more transactions in a Transaction file.
What I need to do is get the transactions ID where some of the transactions equal a specified amount.

Sample Transaction Table Fields

Transaction_ID
TranDate
InvoiceNo
Amount

The query below would give me what I need IF IT WOULD ONLY WORK

SELECT Transaction_ID
FROM AccountsTransactions
WHERE Invoice IN (106263,106262,106367,106367) AND
SUM(Amount) = 2388.60

PLEASE HELP I NEED TO GET THE Transaction_ID of those transaction where the sum = 2388.60

MSSQL Query

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.