How can the quantity of something be less than zero?

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Tom,

Hopefully this will give you a better idea to what I need help with.

1.)  The table structrue is the following

TableName: tbl_ABC Out of Stocks

Field Names: Rebuyer(tesxt), Venid(number), vendor(texxt), part(number),
partdsc(text), Loc(number), OHQTY(number), OOQTY(Number), On Prev List (text)

The primary keys are loc and part.  There are some other fields in this
query, but these are the most important for the purposes of the rebuyers
using this report on a daily basis to buy products with Onhands<=0 (in our
system we can have onhands less than zero if there is a customer backorder
present)

2.)  Some sample data:

TEAM    REBUYER    VENDID    VENDOR    PART    DSC    LOC    OHQTY    OOQTY    ON PREV. LIST
Team VAPLON    BWILLIAM    11261    AIR COOL INDUSTRIAL    269102    52" 5-BLADE DUAL-MOUNT
FAN W/ LIGHT KIT    27    0    30    YES
Team VAPLON    BWILLIAM    11261    AIR COOL INDUSTRIAL    261321    52" 5 BLADE DUAL MOUNT
PADDLE FAN    17    0    125    YES

3.) The SQL code:

SELECT Buyers.Team AS TEAM, [tbl_ABC Out of Stocks].REBUYER, [tbl_ABC Out of
Stocks].VENDID, [tbl_ABC Out of Stocks].VENDOR, [tbl_ABC Out of Stocks].PART,
[tbl_ABC Out of Stocks].DSC, [tbl_ABC Out of Stocks].LOC, [tbl_ABC Out of
Stocks].SHPLOC, [tbl_ABC Out of Stocks].POLOC, [tbl_ABC Out of
Stocks].STOCKED, [tbl_ABC Out of Stocks].ITMDSG, [tbl_ABC Out of
Stocks].PARTTYP, [tbl_ABC Out of Stocks].STKMETH, [tbl_ABC Out of
Stocks].EFFDT, [tbl_ABC Out of Stocks].ORDBEGDT, [tbl_ABC Out of
Stocks].DISCDT, [tbl_ABC Out of Stocks].OHQTY, [tbl_ABC Out of Stocks].OOQTY,
[tbl_ABC Out of Stocks].[QTY IN PC]
FROM [tbl_ABC Out of Stocks] INNER JOIN Buyers ON [tbl_ABC Out of
Stocks].REBUYER = Buyers.Lid
WHERE ((([tbl_ABC Out of Stocks].ITMDSG) In ("A","B","C")))
ORDER BY [tbl_ABC Out of Stocks].ITMDSG, [tbl_ABC Out of Stocks].REBUYER,
[tbl_ABC Out of Stocks].VENDOR;

4.) I believe item #2 is the results that the query products.  

5.)  As you can see there is a column header named "on previous list".  
Right now this value is being populated on a manual basis.  I get the output
from the query and paste it into Excel.  I then open up yesterday's list and
do a vlookup onto today's list to see if a part was on yesterday's list and
is still present today.

what I'd like is for Access to do this for me.  Somehow take a look at
yesterday's data and tell me if the same part/loc combination is on the list
today.

Hope that helps Tom.  I know this explination is long winded but any help
you can provide would be greatly appreciated.

Thanks!