Don't Print Empty Fields
Thanks for the help so far. I am really nearly there now! :smileyhappy:
I hope my last question.....
I've been building a database for my husbands patients. He is going to want to print out 'visit reports' that he can mail to other Doctors.
I need the layouts to include the field labels as otherwise the results don't make any sense
But so that he's not sending out pages of what appear to be empty lists except a couple of results I'd like to be able to only show field labels and fields on the reports that have data in the fields
I've been trying to figure it out, and the only way I can think of doing this is to practically duplicate every field and have some kind of calculation in it that new duplicated field means the name will show if there is a value
But I'm not sure if I'm heading in the right direction or not
Could anyone give me a push towards where I should be heading?