Basically, the Access Help files screwed me over yet again (when will I ever learn?). While the examples in the Help files have double quotes around the datepart type ("w"), using CF it needs to be single-quotes ('w').
Scott
---------------------------
Scott Brady
http://www.scottbrady.net/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
