Unbound field - use SQL to get value

[stevesharpe]

Hello all!

I have a DB which has following fields:
Lot#
Test Method
Type of Test
Test Value
there can be multiple tests per Lot. For a particular Test Method - there will be only 3 tests ran.

What I would like to do is create a 1 line report showing the 3 tests & the value for each test.

The only way I know to do it is a group by query selecting only the specified test method. That will give me the lot #. Then have 3 fields with each field doing an SQL for that lot# and type of test.

Is there another way to do this?

thanks in advance for all help

steve

 

[dhookom]

I would use a subreport to display the test results. Make sure your main report doesn't also include this level of detail.

Duane
Hook'D on Access
MS Access MVP