SELECT
tblMain.ProductCode, tblMain.Product, tblMain.ProducerCountry, tblMain.Unit, Int(PriceOut1) AS Рублей, Mid(Format(PriceOut1,'Standard'), InStr(Format(PriceOut1,'Standard'),',') + 1) AS Копеек, qdfStoresState.Store
FROM
tblMain
INNER JOIN qdfStoresState ON tblMain.ProductCode = qdfStoresState.ProductCode
WHERE (((tblMain.InPriceList)=-1) AND ((qdfStoresState.QuantitySum) > 0) AND ((qdfStoresState.Store) = 'название склада'))
ORDER BY tblMain.Product;

SELECT tblMain.ProductCode, tblMain.Product, tblMain.ProducerCountry, tblMain.Unit, Int(PriceOut1) AS Рублей, Mid(Format(PriceOut1,'Standard'),InStr(Format(PriceOut1,'Standard'),',') + 1) AS Копеек, qdfStoresState.Store, tblArrivalsProducts.ArrivalID
FROM
(tblMain INNER JOIN qdfStoresState ON tblMain.ProductCode = qdfStoresState.ProductCode) INNER JOIN tblArrivalsProducts ON tblMain.ProductCode = tblArrivalsProducts.ProductCode
WHERE
(((qdfStoresState.Store) = название склада') And ((tblMain.InPriceList)=-1) And ((qdfStoresState.QuantitySum) > 0)) AND ((tblArrivalsProducts.ArrivalID) = Код поступления)
ORDER BY
tblMain.Product;