The first method you show to format the date allows to see the date in the desired format but am I mistaken thinking that it will not allow a group by? I mean that although we visually see the dates with the desired format, access still sees it as the "real" value which is not formatted. Thanks
Kevin Robertson
@Reply 2 years ago
If you want to group by a date component this can be done in a query.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 11.
