I have a query that is a dynaset. When I run it it returns the wrong information, i.e. I filtered for a field = value, but it returns extra values for that field! The recordcount is right with the dynaset. When I run the snapshot everything is visably fine on the datasheet. When I use VBA to TransferSpreadsheet with the dynaset I get the right results also. What's going on that the dynaset datasheet view is inaccurate? I've been working with Access for a number of years, but today it has me stumped. Could it be in the ODBC settings with SQL Server 7.0?
Many thanks in advance!