Strange query output, using ODBC interface with M$ Access ...

Hi list,

I'm currently using TSM ODBC (V 5.1.6.0)  interface with an Access 2002 
database (V 10.4302.4219 sp-2), and built a  query looking like :
SELECT SUMMARY.START_TIME, SUMMARY.END_TIME, SUMMARY.ACTIVITY, SUMMARY.ENTITY, 
SUMMARY.BYTES, DateDiff("w",[START_TIME],Now()) AS timediff
FROM SUMMARY
WHERE (((SUMMARY.ACTIVITY)="STGPOOL BACKUP") AND 
((DateDiff("w",[START_TIME],Now()))<1));

Basically, this should extract all "stgpool backup" jobs registered in summary 
table, which have been started during the last day.
Now, this is what  that query returned (snippet of it, sorry for bad formating) 
:

1/7/2003 11:04:11       1/7/2003 11:04:17       BACKUP          PACRS270        
                        10260491        2
15/7/2003 5:00:14       15/7/2003 8:59:32       STGPOOL BACKUP  TAPELTO1_INF_DB 
-> COPYLTO1_INF_DB 202337119489    0
15/7/2003 8:59:32       15/7/2003 8:59:50       STGPOOL BACKUP  DISKPOOL_ARCH 
-> COPYLTO1_ARCH   0       0
15/7/2003 8:59:32       15/7/2003 9:00:46       STGPOOL BACKUP  
DISKPOOL_SQL_LOGS -> COPYLTO1_SQL_LOGS       55377920        0
15/7/2003 8:59:32       15/7/2003 9:01:32       STGPOOL BACKUP  DISKPOOL_DB2_L0 
-> COPYLTO1_DB2_L0 79876096        0
1/7/2003 11:04:57       1/7/2003 11:05:03       BACKUP          PACRS270        
                                10260491        2
15/7/2003 8:59:32       15/7/2003 9:03:58       STGPOOL BACKUP  
DISKPOOL_SQL_META -> COPYLTO1_SQL_META       540672  0
1/7/2003 11:05:42       1/7/2003 11:05:49       BACKUP          PACRS170        
                        10260491        2
15/7/2003 8:59:32       15/7/2003 9:07:49       STGPOOL BACKUP  DISKPOOL_DIR -> 
COPYLTO1_DIR    9502720 0
15/7/2003 8:59:32       15/7/2003 9:19:41       STGPOOL BACKUP  DISKPOOL_DBLOGS 
-> COPYLTO1_DBLOGS 10808274944     0
1/7/2003 11:05:13       1/7/2003 11:05:17       BACKUP          PACRS270        
                                817247  2

So, as one can see, it does neither respect the "ACTIVITY="STGPOOL BACKUP"" 
statement nor the "((DateDiff("w",[START_TIME],Now()))<1))" statement, and when 
looking into TSM activity log, it generates this entry : 
07/21/03 17:02:46 ANR2017I Administrator BAR021 issued command: DEFINE CURSOR 
C9fd726c SQL="SELECT START_TIME,END_TIME,ACTIVITY- ,NUMBER,ENTITY,BYTES FROM 
ADSM.SUMMARY WHERE NUMBER = 1403 OR NUMBER = 1402 OR NUMBER = 1405 OR NUMBER = 
1502 OR NUMBER = 1516 OR NUMBER = 1512 OR NUMBER = 1527 OR NUMBER = 1532 OR 
NUMBER = 1534 OR NUMBER = 1530" 
As you can see, this absolutely doesn't match what I've asked for !
(And curiously, if I try to export data from the same query, using rich text 
format, it generates another output,  still inacurate !)
Does anybody (Andy ?) have an explanation for such a strange behavior ?
Thanks in advance.
Cheers.
Arnaud

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group     |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01       | 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=