Subtracting from lowest value

I have a table that has SeqID, BoxID, Sku, Qty. I have multiple boxes of the same item and want to subtract from the Qty with the lowest SeqID only. What are some examples of doing this?

Feb 20 '09 #1

Follow Post Reply

1571

ck9663

2,878

Expert 2GB

Use MIN() to find which one has the lowest value. Then subtract it from there.

--CK

Feb 20 '09 #2

Similar topics

C / C++

Subtracting pointers: Which type to use to store the result?

31 posts views Thread by Spiro Trikaliotis | last post: by

PHP

how to get lowest value

5 posts views Thread by jayipee | last post: by

C / C++

sort a number highest to lowest

17 posts views Thread by rhitz1218 | last post: by

C / C++

stl map - the lowest and greatest key

4 posts views Thread by tomek milewski | last post: by

C / C++

Finding the lowest score

54 posts views Thread by namcintosh | last post: by

C# / C Sharp

Find the lowest value in an array

30 posts views Thread by =?Utf-8?B?VGhvbWFzVDIy?= | last post: by

Python

Finding lowest value in dictionary of objects, how?

5 posts views Thread by davenet | last post: by

Microsoft Access / VBA

Find Lowest Price in Table

6 posts views Thread by Patrick Fisher | last post: by

Microsoft SQL Server

Subtracting sequentially from multiple sources

3 posts views Thread by nsyr | last post: by

Software Development

What Makes Product Development Lean?

1 post views Thread by beacampos | last post: by

General

AntDB’s latest achievement at Global Distributed Cloud Conference to drive deeper digital transformation of enterprises

reply views Thread by antdb | last post: by

Web Applications

How PDDON's online drawing surprised you?

reply views Thread by pddon | last post: by

General

Top Notch! AntDB database of AsiaInfo passed authoritative test of MIIT

reply views Thread by antdb | last post: by

Microsoft Access / VBA

Group serial number

3 posts views Thread by Bright1Light | last post: by

Microsoft Access / VBA

How to create a custom shortcut menu command

7 posts views Thread by bounthong | last post: by

Microsoft Access / VBA

Button hover shadow

5 posts views Thread by Bright1Light | last post: by

Microsoft Access / VBA

MS Access Query Criteria

1 post views Thread by Computer0300 | last post: by

Microsoft Access / VBA

Set focus but record not selected

1 post views Thread by donraf | last post: by

Post your reply

Similar topics