Rabu, 06 Juli 2016

Re: [MS_AccessPros] Re: Counting dates in a month

That's basically the problem. He wants to display and group by month name and year, but he needs to sort by year and month number.

Art-

To get the result you want you need two queries:

1: qryBaseCalc

SELECT Year([MOVEINDATE]) AS InYear, Month([MOVEINDATE]) AS InMonth, Count(tblTenantListing.ID) AS [Total Move-In] FROM tblTenantListing WHERE (((tblTenantListing.MOVEINDATE) Between #10/1/2015# And #6/30/2016#)) GROUP BY Year([MOVEINDATE]), Month([MOVEINDATE])

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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.