[MS_AccessPros] Re: Help with aggregate query expression

 

Thanks Bill, worked great!

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> 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 (4)

Recent Activity:

• New Members 3

Visit Your Group

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

.

__,_._,___