You can use a VBA function that does that, inside a query, if you
are using Access itself (by opposition to VB, C++, etc) with Jet. There is a
whole bunch of related functions at http://www.mvps.org/access/datetime/date0012.htm
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
