Hello, if i have a value that is 01/18/2012 how would i use formatting so that it just says January? Thanks!!
Hello, if i have a value that is 01/18/2012 how would i use formatting so that it just says January? Thanks!!
Create a field in query with expression using Format function.
Format([datefield],"mmmm")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Try: Format("01/18/2010","mmmm")