when I do that I received and error that it is not part of an aggregate statement.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, July 6, 2016 9:51 AM
Subject: Re: [MS_AccessPros] Re: Counting dates in a month
Art-
See if you can get away with changing the Group By and Order By to:
GROUP BY Format([MOVEINDATE], "yyyy mm")
John
Sent from my iPad
> On Jul 6, 2016, at 17:42, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
>
> GROUP BY Format([MOVEINDATE],"mmmm"" , ""yyyy")
See if you can get away with changing the Group By and Order By to:
GROUP BY Format([MOVEINDATE], "yyyy mm")
John
Sent from my iPad
> On Jul 6, 2016, at 17:42, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
>
> GROUP BY Format([MOVEINDATE],"mmmm"" , ""yyyy")
__._,_.___
Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar