leaving out a field to save space

[warco]

In this inventory database, I have entered different chemical compounds which also can be seperated into individual batches for these compounds.All the batches within the compounds are identical except for their "batch number" But, the daily inventory report tends to be too lengthy with all the batch numbers included. Is there a way to only show the compounds and there specs while leaving out all of the individual batches.

Thanks for your time.

 

[Opengrave]

Remove the batch numbers from the report and set your report to group on compound. This should give you one row for each compound.

 

[warco]

When I group the entries by compound, the compound specs are just repeated for each batch in the compound. My problem may be structural, but if you have any other suggestions, they would be greatly appreciated

 

[warco]

After a few tweaks I found that your solution worked very nicely, but my boss let me know that he changed his mind about saving space in the reports, so I am moving back to the old report. Thanks for your help anyway.