Hi Guys,
After ArnelGP's helpful example last week I can now move forward with my project. This time...
Do I need some form of union query in order to look at the qryAllWHLocat and qryCurrentStockLevel queries?
As always, thanks for looking and for any help that you can offer!
Kind regards
Chris
After ArnelGP's helpful example last week I can now move forward with my project. This time...
- I have a subform that shows warehouse locations (WHLocat) and the current amount of stock that is in that area (CurrentBalance), based on the part number (PartID) that has been entered on the form.
- This subform is looking at the query "qryCurrentStockLevel"
- I have another query called qryAllWHLocat and a corresponding table called WarehouseLocations - both of which simply list EVERY warehouse location I have
Do I need some form of union query in order to look at the qryAllWHLocat and qryCurrentStockLevel queries?
As always, thanks for looking and for any help that you can offer!
Kind regards
Chris