[MS_AccessPros] Re: Help with aggregate query expression

 

You're welcome, James.

-Bill

--- In MS_Access_Professionals@yahoogroups.com, j1eggert <no_reply@...> wrote:
>
> 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 (6)

Recent Activity:

• New Members 3

Visit Your Group

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

.

__,_._,___