Printing only fields with certain keyword

[TaiChi56]

I am not sure if I should be in this forum or the printing forum. Here is what I have. I have an inventory database. Everything is done but I need to be able to print a receipt for any inventory not turned in. It is a student database so the primary key is the Student ID. I have nine fields that are filled out with either:

1. Not, Received, or Not issued. 

I want to be able to print out a receipt showing the student what they still owe us before they are cleared. I am just not sure how to do that. I was thinking maybe a script that looks at the field and only picks out the "Not" , takes that label and puts it on the receipt for example:

Geometry Book: Not 

So the script would see that the Geometry book has not be turned it and prints that out on the receipt. Hope that makes sense. Thank you. 

[Steve Martino]

Are you printing the receipt from the student record?

I would think you would use a script on the student layout that goes to the related records and constrains the found set to only show the 'Not Received' inventory items.

You could probably follow the Invoices starter solution to see how they print a list of 'Unpaid' items.

[webko]

By the sounds of it, that level of normalisation of the data structures has not been achieved - ref the 9 fields...