I have created a receipt table that gives one receipt number for each check received. On this table a customer can pay up to 12 invoices with one check. My problem I have ran into is, when I run a query I only want the fields (invoice #'s) with values (paid amount) in them to return. I don't need to see all 12 fields (Invoice #'s & their amounts) if the customer only paid for say 5.
I know there is a button to "show" checkbox for the fields. By not having the fields show, I could miss an invoice that a customer has paid for and obviously I don't want that.