Retrieve last full week in MS Query
 

I have a query that I need it to give me data for the last full week.
I have this working in Access but the syntax must be different in
Excel.
I know I could use parameters, but want little intervention from
users.
Anyone show me the correct way.
Using Office 2k, querying DB2 database
Thanks,

Glenn
This is what I use in Access.

Code:
--------------------

((Format([SHARE]![CLOSE_DATE],"wwyy"))=Format(DateAdd('ww',-1,Date()),"wwyy")))

--------------------


--
gjack72
------------------------------------------------------------------------
gjack72's Profile: http://www.excelforum.com/member.php...o&userid=30375
View this thread: http://www.excelforum.com/showthread...hreadid=568456