This should work for that....
SELECT datename(wk, INVENTTRANS.DATEFINANCIAL)) AS 'dfWeek'
FROM INVENTTRANS
Glad I could help, thanks for the nice comments.
:)
The thing to remember is that you are sending a query to sql server. It
doesn't matter so much as what application is working with sql (msquery,
access, et..). The thing you need is a good sql server query reference. If
you have access to the sql server cdrom you can install the "Books OnLine"
and you would be surprised at how much information is in there. You will
mainly want to search the T-Sql section since this type of code is Transact
Sql.
Good luck!
"Papegoja" <an*******@devdex.com> wrote in message
news:3f*********************@news.frii.net...
Hi Jerry!
This workt great!!! You rock! Thanks a million! If you lived in Sweden I
would have sent you a bottle of wine!
Maybe you could help perfect the report?
I would like to get MS Query to return the same date in "weeks".
2003-01-01 would be week 1.
I don´t want to have to do this in Excell. I´m pulling the date directly
into a pivottable. And would like the whole report to be self updatable.
Is this possible?
Best regards
/Dani
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!