Jaymin
Registered User.
- Local time
- Today, 23:28
- Joined
- Oct 24, 2011
- Messages
- 70
Hi All,
I am working with Access 2010, on vista.
What I have is a query made up of two tables, one product the other inventory. (see below)
In the product table i have a field called "minimum reorder level".
In the inventory table i have two fields one called "number in stock" and "number on order".
What i want to happen is "number on order" to be filtered by the result, if the "number in stock", is less than "minimum reorder level", if it is, have the result placed in the "number on order" field.
EG. if the "number in stock" = 2 and the "minimum reorder level" = 5 then 3 would be placed in the field "number on order" and only the second record from the query would be visible (see below)
The result of this would mean that the field "number on order" would be populated with the result and the and query would also use this to filter the record.
Hope this makes some sence, and someone is able to help me.
Many thanks for your time :banghead:
I am working with Access 2010, on vista.
What I have is a query made up of two tables, one product the other inventory. (see below)
In the product table i have a field called "minimum reorder level".
In the inventory table i have two fields one called "number in stock" and "number on order".
What i want to happen is "number on order" to be filtered by the result, if the "number in stock", is less than "minimum reorder level", if it is, have the result placed in the "number on order" field.
EG. if the "number in stock" = 2 and the "minimum reorder level" = 5 then 3 would be placed in the field "number on order" and only the second record from the query would be visible (see below)
The result of this would mean that the field "number on order" would be populated with the result and the and query would also use this to filter the record.
Hope this makes some sence, and someone is able to help me.
Many thanks for your time :banghead:
