Thanks for the help!
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Consider
> Proj_Ind_YrMth: Format([CBH_Date]+60,"yyyy/mm")
> or
> Proj_Ind_MthYr: Format([CBH_Date]+60,"mm/yyyy")
>
> Duane Hookom
> MS Access MVP
>
>
> > To: MS_Access_Professionals@yahoogroups.com
> > From: no_reply@yahoogroups.com
> > Date: Tue, 25 Sep 2012 14:21:05 +0000
> > Subject: [MS_AccessPros] Help with aggregate query expression
> >
> > 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
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar