anto.danny
Registered User.
- Local time
- Yesterday, 16:09
- Joined
- Nov 8, 2015
- Messages
- 35
Greetings,
I have table named stock which has a minimum level for items and stock levels at each branch, so the table would have columns Item_name, Minimum_level, North_stock, South_stock, East_stock, West_stock.
Now I want a report that shows items which have gone below the minimum level. As all the branch stock level are in the same table, I don't mind even if the report shows branch's that have stock beyond the minimum level.
I made a report and added query <=[Minimum_level] under all branch in record source.
But the report shows only items that are below minimum level at all four branch's. I want the report to show items that are below minimum level even in a single branch.
I have table named stock which has a minimum level for items and stock levels at each branch, so the table would have columns Item_name, Minimum_level, North_stock, South_stock, East_stock, West_stock.
Now I want a report that shows items which have gone below the minimum level. As all the branch stock level are in the same table, I don't mind even if the report shows branch's that have stock beyond the minimum level.
I made a report and added query <=[Minimum_level] under all branch in record source.
But the report shows only items that are below minimum level at all four branch's. I want the report to show items that are below minimum level even in a single branch.