[MS_AccessPros] Re: Help with aggregate query expression

 

James

Use the Format() function:
Proj_Ind_Date: Format([CBH_Date]+60,"mm/yyyy") will give you:
09/2012.

Proj_Ind_Date: Format([CBH_Date]+60,"mmm - yyyy") will give you:
Sep - 2012

Proj_Ind_Date: Format([CBH_Date]+60,"mmmm - yyyy") will give you:
September - 2012

Check the help files for more ways to use Format().

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

--- In MS_Access_Professionals@yahoogroups.com, j1eggert <no_reply@...> wrote:
>
> I know this is something simple, but my brain is on overload and I need help to get over this hump.
>
> The expression in my aggregate query is: Proj_Ind_Date: [CBH_Date]+60, which works great. However, when I run the query it gives me the short date. How do I add into the express a format for month/year?
>
> Thanks for your help in advance!
>
> v/r,
> James
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___