Software

Ask something
Question Locked

How do I...Omit empty fields from my access report?

0 helpful
8 replies

by paulpiv

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello, I hope someone can help me with this issue I am having with Access. I have a table with various data fields. Some of the fields do not have information in them so they are blank. When I generate a report with the Report Wizard, I want to include the field ONLY IF THERE IS INFORMATION in them, and OMIT THE FIELDS IF EMPTY. I also want to adjust the formatting so that if the field is empty, the height of the space for the variable field (which is directly under a field that is always present) is reduced.

Any ideas people? Thanks a lot.

P

8 replies

by Former member

In your query, try putting "Is Not Null" in the criteria portion of the field
you don't want to show if the field is empty.

Please post back if you have more problems or questions.

by paulpiv

Hi Peconet, thanks for your response. Is there any way to do the same thing using the "reports" function? The reason is, I want to have a uniform format for the report, and I want to pre-define all the parameters I want to be included in the report so it is simple for the person creating the report.

by paulpiv

Aww man that was awesome. This is why I love computers!

by Former member

If so i would like to know if everything is ok.

Please post back if you have more problems or questions.

This discussion is closed to new replies.