Hi, isn't the criteria to shows the months in a seperate field based upon a Date Field -- Mnths: Format ([TDate],MMM)
Example:
TDate: 11/8/2015
Mnths: Nov
I will greatly appreciate it & thanks in advanced!
Hi, isn't the criteria to shows the months in a seperate field based upon a Date Field -- Mnths: Format ([TDate],MMM)
Example:
TDate: 11/8/2015
Mnths: Nov
I will greatly appreciate it & thanks in advanced!
Almost. Need quote marks.
Format([TDate], "mmm")
If you want month number, simply: Month([TDate]).
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.
As always, thanks!