Report Layout Problem

[EssexRob]

im trying to create a report. basically i need the client name, frequency of job, supervisor and the method and specification of the job.

The problem i have is that the method and specification get muddled up (e.g. they either display side by side or display in a format, method/specification/method/specification). i cant seperate them so that it shows continually the method statements and then the specification statements. As they are memo fields i cannot move them up and down the priority.

Thank you for the help

 

[EssexRob]

Thanks, im not sure about this being a normalization problem. The reason its a memo field is because it could be a long statement of text writing, therefore it could not be a text field.

 

[EssexRob]

Thanks for the help.

With my tables i have specification table and method table which join one to many with another table. The reason is all though specifications and method are long memos the same ones tend to be used over and over again. One job could contain at least 3 or 4 method statements

Basically the layout of the report is the top have Job_ID header, Client_Name Header, Frequency_Job Header.

Under this, as you know, theres a section called detail. In this section i have 2 separate fields one called specification and another called method.

The reason its a problem is the text boxes are either placed adjacent to each other which is not how i want it to be displayed in a print format. If (lets say) i place the specification textbox under the method text box then it will display it a method statement followed by a specification statement, followed by another method statement and so on. Therefore this way is muddled.

I need a way it will display all the method statements continously and then display all the specification statements continously.

All very confusing, thanks for any help.

 

[EssexRob]

Thanks a lot for the help

 

[EssexRob]

Just a quick problem. I done the subreports, all working well. However the first record (job1) copies the specification and method on to page2. i.e

Page1 Shows:
Client name etc.
Method:
1
2
3
Specification:
1
2
3

Page 2:
This just shows the same speifcation and method of Job1. Without client name etc.

Page 3 and Onwards:
Shows Job 2 through to the end correctly.

Any ideas anyone? Thanks for the help