leetpg
05-25-2006, 01:46 AM
Hello all,
I am getting a error and i get no help from it.
I have a combo box which connects to my DB. I made a query which reads something like:
SELECT Products.ProductID, Products.ProductName, Products.SupplierID, Products.CategoryID, Products.QuantityPerUnit, Products.UnitPrice,
Products.UnitsInStock, Products.UnitsOnOrder, Products.ReorderLevel, Products.Discontinued, Categories.CategoryName
FROM (Products INNER JOIN
Categories ON Products.CategoryID = Categories.CategoryID)
WHERE (Categories.CategoryName = 'CPU')
I made this in the Query Builder and when i execute it works beautifully. When i hit OK the OK on the Search Critera Builder thing i get a msg box which says: The schema returned by the new query differes from the base query. No help nothing. Any ideas to get around this?
thanx people
I am getting a error and i get no help from it.
I have a combo box which connects to my DB. I made a query which reads something like:
SELECT Products.ProductID, Products.ProductName, Products.SupplierID, Products.CategoryID, Products.QuantityPerUnit, Products.UnitPrice,
Products.UnitsInStock, Products.UnitsOnOrder, Products.ReorderLevel, Products.Discontinued, Categories.CategoryName
FROM (Products INNER JOIN
Categories ON Products.CategoryID = Categories.CategoryID)
WHERE (Categories.CategoryName = 'CPU')
I made this in the Query Builder and when i execute it works beautifully. When i hit OK the OK on the Search Critera Builder thing i get a msg box which says: The schema returned by the new query differes from the base query. No help nothing. Any ideas to get around this?
thanx people