Case statements, too many possiblies, report coding

[Access Greenhorn]

I have created a report for 6 reagents that is a Specifications sheet (spec
sheet). Any combination of reagents may be sent out in a package so I would
like only the descriptions of the reagents in that package to appear in the
report's header. The report is based on a parameter query that searches out
any of the 6 reagents, the parameter being package ID. If a particular
reagent is not included in the package I would like a N/A to appear beside
its name.

I.E: Package X has only reagents 2 and 4 so I would like the following to
appear:

Reagent 1 N/A Reagent 4 Definition

Reagent 2 Definition Reagent 5 N/A

Reagent 3 N/A Reagent 6 N/A

You get the idea.

How do I get Access to do this? If I were to design a case statement I
would need to create one for every possible combination of reagents (that's a
lot). How do I get Access to basically look at which reagents are in the
package and execute code if that reagent is present?

Thanks,
AG

 

[Duane Hookom]

Can you create a totals query that groups by reagent and counts records? You
could use this query with a left or right join to display all reagents. Then
build a subreport based on the totals query so you can display the results.

 

[Access Greenhorn]

Thanks Duane that worked, now I just have to figure out the formatting so
that I get two entries to appear across.

Thanks,
AG

 

[Duane Hookom]

I would use a multiple column subreport.