I have a simple table "InfoTable" with the following fields: "SetID", "Itemized", "Qty"
Try to run a simple query that create to the following statement from the QBE:
SELECT InfoTable.SetID, DSum("Qty","InfoTable","SetID=" & [SetID]) AS TotalQty
FROM InfoTable;
But it produces error:
"The object doesn't contain the Automation object 'Apple.'' " where Apple is one of the record in the SetID. What does it mean?
Try to run a simple query that create to the following statement from the QBE:
SELECT InfoTable.SetID, DSum("Qty","InfoTable","SetID=" & [SetID]) AS TotalQty
FROM InfoTable;
But it produces error:
"The object doesn't contain the Automation object 'Apple.'' " where Apple is one of the record in the SetID. What does it mean?