Seting one fields value based upon mutiple records values

[knikki2000]

I have a report that lists test results for laboratory testing we perform. The test samples are usually all take from the same location or at least in the same state. In rare cases, the test samples come from different locations in different states. This is where my problem comes in.

On page two of the reports, I need to print data that fits each individual states requirements. This is easy in the case where there was only one sample or all have the same state because you can just use the data from the first or last sample. In the case where there is more than one state, it become more complicated.

I know how to query the information and make it print, but i am uncertain how to query the different information for each record.

The report is set up to print all of the reports for a single analysis run with one button push. This means that all 300 test that were performed by 250 different customers will print out all at once.

Any suggestions on how to resolve this problem?

Example one is the simple case that I have already made work. Example two is the more difficult case that I need help with. (these are both very simplified data set as the is much more information included in the reports)

Example 1:

Report Page One:

John Doe
123 street
Anytown, IL 12345

Test #1 - 123 Street, anytown IL
Test #2 - 125 Street, Anytown, IL

Report Page Two:

The state of IL says "blah, blah, blah". for more information contact them at 123-456-7890


Example 2:

Report Page One:

John Doe
123 street
Anytown, IL 12345

Test #1 - 123 Street, Anytown IL
Test #2 - 125 Street, Sometown, MN

Report Page Two:

The state of IL says "blah, blah, blah". For more information contact them at 123-456-7890.

The state of MN says "blah, blah, blah". For more information contact them at 098-765-4321.