Re: [MS_AccessPros] Birthdays Report

 

could be it is giving 1 and then 9 ... and there is no space between the 2 values ...

respectfully,
crystal

~ have an awesome day ~

On 8/30/2016 12:21 AM, graham@mandeno.com [MS_Access_Professionals] wrote:

Hi Robin

You don't perchance have your own function called "Month" do you?  That is the ONLY possible explanation I can think of for the function to return 19.

What happens if you open the Immediate Window (Ctrl-G) and type:

?Month(Date) <enter>

It should return 8 (this being August).

-- Graham

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Robin-

The Month function should return values 1 to 12.  It should never return 19!  Is birthdate a Date / Time field?

John Viescas, author

Effective SQL

SQL Queries for Mere Mortals

Microsoft Office Access 2010 Inside Out

Microsoft Office Access 2007 Inside Out

Building Access Applications

http://www.viescas.com/

On Aug 29, 2016, at 23:48, Robin Chapple robinski@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Duane,

The month provides numeral 1 for the first group and numeral 19 for the second group. There are no other groups.

The day gives the day date for each entry.

I hope that means something to you!

Thanks,

Robin

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

 

Robin,

Add a text box to the month group header with a control source of:

=Month([birthdate])

Add a control to the detail section with a control source of:

=Day([birthdate])

What do you see when you run the report?

Duane Hookom

---

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 29 Aug 2016 08:24:37 +1000
Subject: RE: [MS_AccessPros] Birthdays Report



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,

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: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (15)

---

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.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___