Senin, 29 Agustus 2016

Re: [MS_AccessPros] Birthdays Report

 


Yes John.

At 29/08/2016 03:36 PM, you wrote:

 

Robin-

Did you define the group on month first, then the sort on day after that?

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 29, 2016, at 12:24 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:



Thanks Duane,

I have now done that and the first group shows January as the first month and lists birthdays in ascending order.

The next group header is May with all the remaining birthdays in random order. There is not another month group header

What have I missed?

Regards,< /span>

Robin


At 26/08/2016 08:17 PM, you wrote:
 

Robin,
 
Display the report sorting and group. Then select to group by the expression:
  Month([birthdate])
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: Robin Chapple <robinski@westnet.com.au>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (12)

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:

Poskan Komentar