Parts Management Database Help Needed

[rlt3330]

I created a basic access 2003 data base to manage spare parts. The table has four fields: Stock Number, New Qty, Serviceable Qty & Repairable Qty. The table is updated by importing an Excell spread sheet. Previously a query would sum the New Qty and the Serviceable Qty Fields. Then I'd run another query that would compare the Repairable Qty to the (New Qty + Servicable Qty total). If the Repairable Qty was greater than or equal to the (New Qty + Servicable Qty total) it would only find those records. I was having troubles with null values and while attempting to repair the queries I corrupted them. Now I'm having troubles rebulding the queries (two years later... I fogot how I did them and I can't figure it out)

[JustJim]

I created a basic access 2003 data base to manage spare parts. The table has four fields: Stock Number, New Qty, Serviceable Qty & Repairable Qty. The table is updated by importing an Excell spread sheet. Previously a query would sum the New Qty and the Serviceable Qty Fields. Then I'd run another query that would compare the Repairable Qty to the (New Qty + Servicable Qty total). If the Repairable Qty was greater than or equal to the (New Qty + Servicable Qty total) it would only find those records. I was having troubles with null values and while attempting to repair the queries I corrupted them. Now I'm having troubles rebulding the queries (two years later... I fogot how I did them and I can't figure it out)

Try this:

SELECT Part.PartStockNumber, Part.PartNewQuantity, Part.PartServiceableQuantity, Part.PartRepairableQuantity
FROM Part
WHERE (([PartRepairableQuantity]>=[PartNewQuantity]+[PartServiceableQuantity]));

where Part is the table name and PartStockNumber (PK, autonumber), PartNewQuantity, PartServiceableQuantity and PartRepairableQuantity are (Long) fields in that table.

Good luck

Jim