mugcy
04-02-2009, 09:51 PM
I have 2 tables. First called "Stock" with feilds Storeno, Type, StockCode, CountDate, Stockcount.
2nd a query table created with the following SQL statement:
SELECT *
FROM Stock
WHERE ((Stock.StockCount<>0.1) AND (Stock.StockCount<>0.01));
When I run the query I get the SQL quer in the first cell of the table it self ()Please check attachment).
How can I get rid of this and have the store no in that cell.
file:///C:/DOCUME%7E1/mewan/LOCALS%7E1/Temp/moz-screenshot.jpg
2nd a query table created with the following SQL statement:
SELECT *
FROM Stock
WHERE ((Stock.StockCount<>0.1) AND (Stock.StockCount<>0.01));
When I run the query I get the SQL quer in the first cell of the table it self ()Please check attachment).
How can I get rid of this and have the store no in that cell.
file:///C:/DOCUME%7E1/mewan/LOCALS%7E1/Temp/moz-screenshot.jpg