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 relatively well, but it requires me to import the inventory contained on my iPhone into the Access database. To avoid running into major problems, I've designed a few queries to analyze the data on the iPhone inventory to make sure it matches the data in the main Access database before I actually update it.
The main problem I'm having is that I use an inventory table and I also use an inventory detail subtable because I usually have to store products in more than one location. I've tried to design a query that will show me when items on the iPhone don't match the storage location in the main database. For items that are stored in more than one location, it returns the records in the alternate location, even though it is actually matched up in the primary location. I only want the query to display records that don't match anywhere so that I can adjust the location field either on my phone or on the main database.
For example, say I store BBQ sauce in both the fridge and the pantry. I use the iPhone to add or remove items from the pantry because that is where most of this activity occurs. The update query will only update the quantity from the iPhone inventory into the Access database where the locations match. Things get moved around from time to time, so I need to be able to check both tables and make sure the primary location matches in both tables so that the quantities will be updated accurately.
Is there a way to design a query that will display records that don't match a particular field if and only if they don't already match elsewhere in the table?
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 relatively well, but it requires me to import the inventory contained on my iPhone into the Access database. To avoid running into major problems, I've designed a few queries to analyze the data on the iPhone inventory to make sure it matches the data in the main Access database before I actually update it.
The main problem I'm having is that I use an inventory table and I also use an inventory detail subtable because I usually have to store products in more than one location. I've tried to design a query that will show me when items on the iPhone don't match the storage location in the main database. For items that are stored in more than one location, it returns the records in the alternate location, even though it is actually matched up in the primary location. I only want the query to display records that don't match anywhere so that I can adjust the location field either on my phone or on the main database.
For example, say I store BBQ sauce in both the fridge and the pantry. I use the iPhone to add or remove items from the pantry because that is where most of this activity occurs. The update query will only update the quantity from the iPhone inventory into the Access database where the locations match. Things get moved around from time to time, so I need to be able to check both tables and make sure the primary location matches in both tables so that the quantities will be updated accurately.
Is there a way to design a query that will display records that don't match a particular field if and only if they don't already match elsewhere in the table?