"Note that you can also simply select the birth date field in the Select Field drop down, then click More… and in the "by entire Value" area, click down and select Month for the grouping and Day for the sorting." I think this might also include the year in the grouping making separate groups for months in different years.
On Sat, Aug 27, 2016 at 2:34 AM +0200, "Robin Chapple robinski@westnet.com.au [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Thanks for that John. All is working now as planned.
Best wishes,
Robin
At 27/08/2016 08:55 AM, you wrote:
Robin-
With your report in Design View, click on Group & Sort in the Grouping and Totals group to reveal the Group, Sort, and Total window at the bottom. Click Add a Group, then click on the down arrow next to the Select Field area, then click Expression to open the Expression Builder. Type in Month([BirthDate]) and click OK. (This assumes that the name of the field containing the birth date is called BirthDate - correct as needed.)
On the next level down, click on Add a Sort and then sort on Day([BirthDate]),
Note that you can also simply select the birth date field in the Select Field drop down, then click More… and in the "by entire Value" area,, click down and select Month for the grouping and Day for the sorting.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
http://www.viescas.com/
(Paris, France)
On Aug 26, 2016, at 3:00 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:
Thanks Duane,
I regret that I do not understand the steps that I must take.
At 26/08/2016 08:17 PM, you wrote:
Display the report sorting and group. Then select to group by the expression:
Month([birthdate])
I have the "Group, Sort and Total" displayed but cannot see where to place the expression.
Many thanks,
Robin
Then add another sorting expression of:
Day([birthdate])
You can format the [birthdate] text boxes in your report sections to display whatever you want.
Regards,
Duane
> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 26 Aug 2016 14:02:03 +1000
>
> I have a members database which includes their birthdays. I plan to
> make a report that groups birthdays on the month and then sorts them
> by the day.
>
> How do I do that?
>
> Many thanks,
>
> Robin Chapple
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
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