Report layout help

[marthacasting]

I am still trying to create a report that shows one record per page, with each record consisting of about 50 fields. I've tried the suggestion of starting with creating a report using just a few of the fields and then adding in fields a couple at a time. I am relatively new to creating reports, but I don't know how to do that so the fields are not all "connected" to each other (either in Reports or Forms). Is it possible move/manipulate each field individually (kind of like moving text boxes in Publisher or Word)?

Thanks for any help/insight!

 

[vbaInet]

The following link should give you some pointers:

http://office.microsoft.com/en-us/ac...010006894.aspx

Also, look into the Force New Page property of a Group Footer's section.

 

[marthacasting]

Thank you for this. So I have it so that only one record (person) shows per page; however, the 50 fields run across the top of the multiple pages, so that each record/person is pages & pages long, with squished info in each field.
Is there a way to manually move each of the 50 fields around, individually, on the page?

 

[vbaInet]

Sounds like you are running your report off one table?

 

[marthacasting]

Yes. Actually I have one large table (>10,000 records), and from that I create many queries; each query has 14-20 records; each record has 50-60 fields. So the reports are based off of the queries.

 

[vbaInet]

What kind of details does your table hold? Details of each customer with their orders, address details etc?

 

[marthacasting]

Yes, demographic information as well as medical/personal information. So I need to capture all that information for each person on his own page.

 

[vbaInet]

Is this an import from a properly normalized database?

Move the controls around until you get the perfect fit. For example, you can stack the controls.