Hi all. Is there any way to have Access generate a custom report including only the fields that are populated in a form?
I have a form to log customer product quality complaints with a subform that has 20 different fields to record the results of quality control testing of the suspect product. However only a few of the fields will be populated at any one time depending on the product and/or customer. I would like to have a button on the form that will generate a custom report to be issued to the customer with the results of the sample testing. However I only want to include the fields that are populated and have the report formatted accordingly.
Seems like it should be possible but I'm having a hard time making it work. Any ideas?
I have a form to log customer product quality complaints with a subform that has 20 different fields to record the results of quality control testing of the suspect product. However only a few of the fields will be populated at any one time depending on the product and/or customer. I would like to have a button on the form that will generate a custom report to be issued to the customer with the results of the sample testing. However I only want to include the fields that are populated and have the report formatted accordingly.
Seems like it should be possible but I'm having a hard time making it work. Any ideas?
Last edited: