Recent content by losdamianos

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...

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...

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...