Unanswered: Incorrect query result .... Access 2000
This one is driving me nuts!!!! Check the following code:
SQLString = "SELECT Sum([Items Inventory].OnHand) AS Expr1 FROM [Items Inventory]"
SQLString = SQLString & " WHERE ([Items Inventory].ItemID=" & ID & ");"
Now running this query using ADO returns a result! THE TABLE THE QUERY IS BASED ON IS EMPTY! The result returned is the ID # provided. If I run this same exact query in the QBE only replacing the ID # with an actual number it returns a null set like it should ... Any ideas on what the **** is going on?