Search results

That worked like a charm once again ByteMyzer. Thank you very much! It was kind of a pain having to look up the storage location code every time I ran the previous query to see what the number meant. So much easier to see the discrepencies between the two inventories. I'd love to learn more...

Oh sorry. The StorageLocations table only contains 2 fields StorageID (an Autonumber field) and StorageLocation which is the name of the location. The StorageID field would match the location number stored in the iPhone table.

OK, now I also have a minor tweak I would like to add to this query if I could. For the main database field, the query returns the text name of the storage location, but for the iPhone database field, the query returns the number of the storage location instead which requires me to manually...

That SQL statement worked like a charm. Thank you so much ByteMyzer. I've been trying to figure out a solution to this problem for ages. I figured there had to be some sort of code that could perform this operation. After using this query, it returned 6 results instead of the usual 100 or so...

I'm sure that will help clarify what I'm trying to do. I use 3 tables in order to import my iPhone inventory into the main one: Inventory ProductID ProductName ProductDescription Container UnitSize UnitPrice FoodCategoryID ReorderLevel SupplierCategoryID Discontinued BarCode Inventory Detail...

Hello everyone! I've been having trouble designing a query and I'm hoping someone here can point me in the right direction. I use an iPhone app which allows me to scan barcodes of items that I keep in my inventory so that I can add or remove them just by scanning the barcode. It works...