Retrieve last full week in MS Query

G

gjack72

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 i
Excel.
I know I could use parameters, but want little intervention fro
users.
Anyone show me the correct way.
Using Office 2k, querying DB2 database
Thanks,

Glenn
This is what I use in Access.

Code
 
Top