View Full Version : Displaying limited entries & Month sort question


RiverLee
01-06-2009, 10:32 PM
I apologize if these are extremely easy questions, I am very new to Access but recognize how useful it is and am willing to learn.

I'm using the program, not displaying information on a webpage, if that makes any difference.

1. ) I have been using the contact database for access 2007 and have created a report, however, it is showing more information than I would like: IE I have many different Companies but would only like to show one company's contact information in a certain way, then display another company's information on the same page slightly differently (or with different data types, cell numbers, or extensions etc..).


2. ) I have another contact database used personally in which I would like to display people's birthday's by month. I am currently able to display their birthday's by month, however, it also separates them into the years which I would like to be ignored.


Thanks to everyone who is willing to help me!

namliam
01-07-2009, 12:26 AM
1)
Different layout = different report. You can change a little the look and feel of the report using "Conditional formatting" found in the menu while in design view of your report. But its use is limitted, if you want a total different layout, you need a different report.

2)
You should group by Month(DateOfBirth), how are you grouping the report now?

RiverLee
01-07-2009, 07:24 AM
Thank you for replying but I'm still quite confused.

1.) Is it possible to have conditional formatting to say if = X then display future categories y & z, otherwise show a & b? I dont need to completely change the layout just which information is shown to reduce white space.

2. ) I have tried entering that into the wizard when I create a report and in the group and sort view but the first gave me an error and the second only lets me choose what is in a drop down menu. Where to I enter that?

namliam
01-07-2009, 07:29 AM
1)
You can do 'something' like that in a query... using an IIF try it and see how far you get.

2)
A query... make a query and add that to the fields.