Access Access 2007 Report Question

J

JBren

Joined
Oct 10, 2012
Messages
16
Reaction score
0
Building a database and I've got most of it figured out so far. However, I'm stuck on this one part. I've got a table with all the info I need in it and now I want to generate a birthday list with a specific layout. I built a query to pull first name, last name, and birthday but I don't want the birth year to show in the report, just the month and the day. Then I would like to sort them by the month. Is this possible or should I redesign the table so that the month and the day are in one field and the year is in another?
 
Without trying it, I have the following advice, if you need me to ellaborate, I can build a simple database to try it and explain further.
I would add a separate field to the query that shows just the month. Then on the report, I would add grouping, and group the report by Month and sort it in Ascending Month order that way. If you need further explaination of this, let me know.
 
Ok, that made sense for sorting by month. What can I do about the birth year though? It still shows up in the report and I want it hidden.
 
I'm pretty sure that can be done with a custom format that only includes the Day or Month, or even only the Day, but I'll have to play around with it to tell you for sure.
 
Got it, I think. If you just want to show the days or months, or whatever, you just need to go into the properties (Alt+Enter with the text box selected) for the text box that shows the dates, and go to the format tab. Type in how you want the date to look using m and d placeholders.

mm for 2 digit month
dd for 2 digit year
m/dd for month/2 digit year
mm/dd for 2 digit month/2 digit year

and so on. Let me know if that clears it up!
 
Got it! Thanks! It's working good now!

Edit:

Formatting works fine but I just noticed my query isn't pulling all the information I wanted. -sigh- Why me?
 
Last edited:
With queries missing data, I find the best way to find the problem is to start a new query with all the required fields and no criteria, and see what you get. If you see the data that's missing there, then there's a problem with the criteria. If you don't see the missing data there, there is probably a problem with the database relationships (usually a bad join). Let me know if that sets you on the right path, otherwise, give some more info about what's going wrong with the query and I'll see if I can help.
 
I'll have to upload a sample database when I get back to work so you can see it. I don't know how to explain it clearly.
 
Back
Top