Formatting of Report - HUGE PROBLEM FOR ME!!!

[krishill]

Ok, this is my BIGGEST problem of all trying to figure this all out (if you've seen my other questions).

Please see the attached Word document. Please look at page 2 of that document.

Now...is there ANY way possible to have this REPORT be put into Access and look at least almost like it?????? My specific problems are 1) Getting it to be multi-columns when page 1 isn't, 2) the formatting being all different, such as heading, sub-head, sub-sub head, etc, all different sizes/fonts, and 3) I need the report length to depend on how many items are in the objectives, whether the report be 2, 3, or 4 pages or more.

Ok, so what are my options with this? Do I have ANY? If I have to do the simple route of just attaching a Word document (and leaving the report in Word), then I would have to create a Word document and manually attach it every time someone adds a record to my table, right?!?!?! That just does NOT sound efficient!

Thanks soooooo much, I really really have tried to find the answer to this myself!!!!!

Kris

 

[Pat Hartman]

You'll have to work to get everything to line up properly but you should be able to do it. Create 8 subreports to show the separate sections of page 1. Put them in the detail section of the main report. Put a page break after them. Then the page2 and on data is a simple 1-to-many relationship.

 

[krishill]

Please see report

Thanks Pat for your reply! Please take a look at my database attached. You can see the form and the report from it that I use. I think I have page 1 ok, don't I? But I really don't understand what you're saying about page 2 and on. Could you please elaborate a little on that last sentence (and let me know what you think of page 1)?

Thanks again! Have a great day!

Kris

 

[Pat Hartman]

Sorry to be so long, I've been away playing bridge and am way behind on checking in here.

You have used a single table but you should have used several. Each of the blocks of data should come from a separate table. They each have a many-to-one relationship with student or course. Do some reading on database normalization before continuing. You are making way too much work for yourself and are boxing yourself into a corner. What are you going to do if next semester one of the courses requires more than 7 items?

A page break is one of the choices in the toolbox.

 

[krishill]

Thank you Pat!

Thank you so much Pat. That's like the one thing I was NOT looking at, thinking that it was ok. lol I have now printed out a ton of info on Normalization and will work some more on my table(s). Again, thanks a bunch! Keep your fingers crossed I understand all this stuff I printed now! lol Have a great day & weekend!

 

[krishill]

relationships?

I have a question for you Pat (or anyone else who can answer). I guess I don't really understand why I need separate tables for each section of my report. Every field on it has to do with the course. It's not like I have info on there about students, or schools, or some separate category, they all relate to the course. Everything I've read shows how to separate categories, which I don't see how mine relate to that. Can you help?!?!!?!? I'm still reading!

 

[krishill]

Pat - Please see my other thread posting!

Hi Pat!!! Please see my thread posting at:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=50197

I started to do it as a reply to this but it really isn't a REPORT question so I didn't want to post it in the wrong place!

Let me know if you can help further with this monster!!! )

Have a great weekend!

Kris