Search results

  1. L

    Select DISTINCT columns along with a NON-DISTINCT column

    Hi namliam thanks for the reply Basically what Im trying to do is create some sort of query which will help find a locations for each SKU. I need to design warehouse stock controll database. Where I have Fields like Location (JA001A) JA-JK are racks 001 - 042 columns and A-H are rows (A is...
  2. L

    Select DISTINCT columns along with a NON-DISTINCT column

    Hi all! Im trying to run a query which will find some DISTINCT (unique fields) and I want to add other fields to them as well when I run SELECT DISTINCT Find_Items.Sku FROM Find_Items; It work well but I want to add some other fields to the query such as SKU Location and quantity, so when I...
  3. L

    Report from .CSV query ?

    HI all ! Ok here is the story. I have created simple database for the warehouse where each SKU has unique location. Everyday I get mail with the orders with 10-15 SKU`s (each order) and I need to find locations for them. Well Im doing it manually and it takes just too long. Is there any way to...
Back
Top Bottom