RE: [MS_AccessPros] Help with aggregate query expression

 

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]

__._,_.___

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

Messages in this topic (2)

Recent Activity:

• New Members 3

Visit Your Group

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

.

__,_._,___