Access to flowfields via ODBC / Access

Christian_BuehlChristian_Buehl Member Posts: 145
I'm a little bit confused now :roll: while I tried the following:

With MS-Access and the ODBC driver I tried to access a flowfield as described in the C/ODBC guide. I tried to enter this sql-command in MS-Access:
SELECT No_, Name, Net_Change
FROM G_L_Account
WHERE Date_Filter='010404..300404';

The result is the net_change but it seems that the flowfilter was not set (as should be). After some tests I tried to use msquery32 with the exactly same sql-statement. I was lucky because it worked right and the filter was correctly used.
Does anyone know the reason for this strange behaviour?
Is there any setting for MS-Access to make the filter happen?

(I'm using the native database in version 3.70.A with corresponding ODBC-Driver and Access XP)
Sign In or Register to comment.