I'm trying to retrieve any rows added in the past week and using the Query Builder in acc97 gave me this...

SELECT quickLists.quickListID, quickLists.listTitle, quickLists.listSource, quickLists.numItems
FROM quickLists
WHERE (((quickLists.dateCreated)>DateAdd("ww",-1,Now())));

The error that appears when I display my ASP page is this ...
---------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access 97 Driver] Unknown function name in query expression '(((quickLists.dateCreated)>DateAdd("ww&#3 4;,-1,Now())))'.
---------

Am I just not able to use the DateAdd function in a query of this type? And if not, why is it provided for in the querybuilder? And, one last question, what would be a solution to what I need to do?

Matte Edens
Web Producer - KNTV NewsChannel 11 / KBWB WB20
webmaster@kntv.com