This sample ODBC query will return the Current Quantity on Hand, Average Cost, Current on Hand Value and Reorder Point of items based on specific location.
SELECT LOCATIONS.FULL_NAME, ITEM_LOCATION_MAP.ITEM_ID, INVENTORY_ITEMS.FULL_NAME,
FROM "Full Access".ITEM_LOCATION_MAP
INNER JOIN "Full Access".INVENTORY_ITEMS ON ITEM_LOCATION_MAP.ITEM_ID = INVENTORY_ITEMS.ITEM_ID
INNER JOIN "Full Access".LOCATIONS ON ITEM_LOCATION_MAP.LOCATION_ID = LOCATIONS.LOCATION_ID
WHERE LOCATION_ID = [LOC_ID]
*LOC_ID = Internal ID of location