Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Problems with combining data in reports. (http://www.go4expert.com/forums/combining-data-reports-t20713/)

knikki2000 21Jan2010 02:09

Problems with combining data in reports.
 
I have a report that lists test results for laboratory testing we perform. The test samples are usually all taken from the same location or are at least from 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.

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

Below are two simplified examples of how I need the data to print out. Example 1 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) The report data come from a query that combines data from multiple tables.


*****************************************
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.
*********************************************


Please let me know of any information that you may need to help with this problem.


All times are GMT +5.5. The time now is 21:33.