Birthday with only Month/Day

[akh2010]

Hello!

I'm trying to create a table with an entry for month/day, no year. I want to create a report that can will sort the birthdays based on month in ascending order. Any suggestions?

I'm currently using the text field to put in, "10/30" or "1/3" but when I try to order the dates, instead of "1,2,3,4,5,6..." I get "1, 10, 11, 12, 2, 3.." etc.

I would appreciate any suggestions!

Thanks.

 

[RuralGuy]

Use numerical fields and separate the Month and the Day.

 

[akh2010]

How do I get it to say "10/30" etc later on in the query and the report? I tried doing in query BirthDate: [BirthMonth]+"/"+[BirthDay], but that didn't work. I tried [BirthMonth]+"/"+[BirthDay] in the calculated field, but that didn't work either.

Thanks for your response.

 

[RuralGuy]

Use Birthdate: BirthMonth & "/" & BirthDay

 

[akh2010]

I tried what you suggested, putting the birth month and dates in separate columns. Then in query, I did the [BirthMonth]&"/"&[BirthDay], and then I sorted it by Ascending, but it still is ordering the birthdays by the first number, i.e. my birthdays are ordered "1, 10, 11, 12, 2, 3, 4" etc. How can I fix this?

Thanks.

 

[RuralGuy]

You did not use Integer fields did you? It is sorting like they are strings.

 

[akh2010]

Sorry, I'm not really sure what you mean.

For the fields, I picked "Number" type and put in the numbers. I thought you might have meant the Field Size, so I went and changed it from Long Integer to Integer, but that doesn't appear to be what you're talking about.

 

[RuralGuy]

Are you sorting on those fields?

 

[nanscombe]

As RuralGuy said ..

Use Birthdate: BirthMonth & "/" & BirthDay

But sort on BirthMonth first then BirthDay, If you want to hide the fields just remove the tick from the show box of the fields.

Field - Birthdate: BirthMonth & "/" & BirthDay
Sort -
Show - Tick

Field - BirthMonth
Sort - Ascending
Show - No Tick

Field - BirthDay
Sort - Ascending
Show - No Tick

 

[akh2010]

Thank you for your responses, everyone! Having two separate columns, one for month and day with the hidden sorting works! I really appreciate your answers.