Selasa, 25 September 2012

[MS_AccessPros] Re: Help with aggregate query expression

 

Hey Duane, Bill,

Great minds think alike(almost) and they are fast <G>.

Regards, Clive.

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar