Problems w/report

[papabill]

As I've said earlier, I'm still working on my church directory with Microsoft Access 2007, and I have all the information I can gather from all the members.



However, when I start to create the report, I can only put information for one person per "row". (Let's see if I can explain better)

On an 8 1/2" x 11" page, there is only one person per row. The only information I'm printing on THIS report is a picture, name, and birthdate. That only takes up 3 1/2" of an 8 1/2" page (one "column"). I'd like to put the NEXT person (alphabetically) on the next column on the same row, so that I'd have two individuals per row. On an 11" page, I can get 4 rows of information.

The only way I have figured out how to do it is to make 2 queries and create 2 reports, printing one report first, then the 2nd report on the same page, only 4 inches to the right of the 1st report.

Does any of that make sense?

Thanks

[pbaldy]

Try going into Page Setup and play with the settings on the Column tab.

[June7]

Have you looked at multi-column settings on the Page Setup tab when report in layout or design view?

[papabill]

No, I didn't know anything about that. That's how much I DON'T know about Access

[papabill]

Well, knowing about the Page Setup worked wonders for me, thanks.

Now I have ANOTHER problem (naturally).

In setting up the report for all the members, I have a field for cell phones and a field for email addresses, however, some of them don't have cell phones or email addresses. I need to know how to set up the report with blank spaces in place of cell phones and email addresses for those who don't have them. (Does THAT make sense?)

Here is the report setup:
[Member name] [Address] [Home Phone] [Cell Phone] [Email Address]

[pbaldy]

I'm not clear on the problem. If each field has a textbox to display it, an empty space would be left in place of empty fields. You can use the Nz() or IIf() functions to replace blank fields with something else.

[papabill]

Thanks, I'll study on that.

[papabill]

I'm not clear on the problem. If each field has a textbox to display it, an empty space would be left in place of empty fields. You can use the Nz() or IIf() functions to replace blank fields with something else.

I'm sorry, but my puny little mind cannot fathom this information. I'm still trying to figure this out.

Here is my report setup:

  
Family Name: Morgan
First Name:   Michael
Address:       415 Jones Street
City:             Pensacola
State:           FL
Zip:              12345
Home phone: 555-123-4567
Cell phone:    555-446-2345
Emai:            mmorgan@yahoo.com        
Birthday:       10/17  
Spouse:        Louise
Birthday:       4-16
Cell phone:    555-446-2317
Email:           lmorgan@yahoo.com
Anniversary: 6/21                                     
Child 1:         David      
Birthday:       4/21                      
Child 2:         Jenny   
Birthday:       2/24
Child 3:                 
Birthday:              
Child 4:                 
Birthday:

I have quite a few single and widowed members who have no ‘Spouse’, ‘Spouse birthday’, ‘Spouse cell ’, ‘‘Spouse email’,
‘Anniversary’, ‘Child 1’ , ‘Birthday1’ , ‘Child 2’ , ‘Birthday2’ , ‘Child 3’ , ‘Birthday3’ , ‘Child 4’ , ‘Birthday4’

Instead of having a lot of empty headers, how can I make the headers not even appear if they are null?

[June7]

I don't think you can with that arrangement. The labels each occupy a line.

[pbaldy]

Are you saying you don't want to see the label? That would be fairly easy. You'd test the field and toggle the visibility of the label in the detail format event. If you want that line to disappear and the lines below moved up, that would be trickier.