Access+Excel Queries and reports

SELECT PrimaryPrices.Store AS StoreID, PrimaryPrices.UnitTotal AS PrimaryUnitTotal, PrimaryPrices.UnitPrice AS PrimaryUnitPrice, PrimaryPrices.ExtraCosts AS PrimaryExtraCosts, [qryPrices].[UnitTotal]-[PrimaryPrices].[UnitTotal] AS UnitTotalDifference, qryPrices.*, PrimaryPrices.StoreName AS PrimaryStoreName FROM qryPrices AS PrimaryPrices INNER JOIN qryPrices ON PrimaryPrices.Product=qryPrices.Product;

SELECT HistoricalPrices.*, "Update" AS Update, Products.ProductName, Stores.StoreName, Categories.[items to buy] FROM Stores INNER JOIN ((Categories INNER JOIN Products ON Categories.ID=Products.Category) INNER JOIN HistoricalPrices ON Products.ID=HistoricalPrices.Product) ON Stores.ID=HistoricalPrices.Store WHERE [Products].[Archived]=False And [Stores].[Archived]=False ORDER BY Products.ProductName;

SELECT Prices.*, "Update" AS Update, Products.ProductName, Stores.StoreName, Products.Category, Categories.[items to buy] FROM Stores INNER JOIN ((Categories INNER JOIN Products ON Categories.ID=Products.Category) INNER JOIN Prices ON Products.ID=Prices.Product) ON Stores.ID=Prices.Store WHERE [Stores].[Archived]=False And [Products].[Archived]=False ORDER BY Prices.UnitPrice;

PARAMETERS prmStore1 IEEEDouble, prmStore2 IEEEDouble; SELECT Store1Prices.*, Store2Prices.*, [Store1Prices].[UnitTotal]-[Store2Prices].[UnitTotal] AS Difference FROM qryPrices AS Store1Prices INNER JOIN qryPrices AS Store2Prices ON Store1Prices.Product=Store2Prices.Product WHERE [Store1Prices].[Store]=[prmStore1] And [Store2Prices].[Store]=[prmStore2];

SELECT Categories.ID, Categories.[items to buy] FROM Categories ORDER BY Categories.[items to buy];

SELECT Stores.ID, Stores.StoreName FROM Stores ORDER BY Stores.StoreName;

SELECT Products.ID, Products.ProductName FROM Products ORDER BY Products.ProductName;

SELECT Categories.ID, Categories.[items to buy] FROM Categories ORDER BY Categories.[items to buy];

SELECT DISTINCTROW * FROM Products;

SELECT Stores.ID, Stores.StoreName FROM Stores WHERE [Stores].[Archived]=False ORDER BY Stores.StoreName;

SELECT Products.ID, Products.ProductName FROM Products WHERE [Products].[Archived]=False ORDER BY Products.ProductName;

PARAMETERS __ID Value; SELECT DISTINCTROW * FROM qryHistoricalPrices AS ProductDetails WHERE ([__ID] = Product);

PARAMETERS __ID Value; SELECT DISTINCTROW * FROM qryPrices AS ProductDetails WHERE ([__ID] = Product);

PARAMETERS __ID Value; SELECT DISTINCTROW * FROM qryHistoricalPrices AS StoreDetails WHERE ([__ID] = Store);

PARAMETERS __ID Value; SELECT DISTINCTROW * FROM qryPrices AS StoreDetails WHERE ([__ID] = Store);

SELECT DISTINCTROW * FROM Stores;

SELECT Categories.ID, Categories.[items to buy] FROM Categories ORDER BY Categories.[items to buy];

SELECT DISTINCTROW * FROM Products;