How to make negative values and positive values affect queries differenly.

[ktg]

I have created an Access 2010 Database for tracking inventory. As parts move to each location, quantities automatically subtract from the previous location. I now realized that some parts are destroyed. The problem is the if I simply enter a negative value to indicated that a part was destroyed at one location, it appears as a positive value in the previous location. Is there a way to make negative values not affect a specific query?

[ranman256]

I would say, if the value is negative -dont run that 'subtracting' query.
otherwise run both.

[ktg]

I need to run the subtracting query because of the way that I have set up of the system.

Is there a way to make a query not recognize negative values?

[ItsMe]

...Is there a way to make a query not recognize negative values?

Queries retrieve data. You could add criteria to the query that would be included in a WHERE clause

Something like
WHERE [tblName].[FieldName] >0

[ktg]

Thanks, I got it!