Access - Null Values

Hi Claire

Thank you for your question.

If you are aware ahead of running the query which fields will be blank, then you can simply hide them when the query runs. To do this simply go to the query design view and in the "show" row simply remove the tick from the relevant fields.

If however,you do not know which rows are null beforehand, then there is no way you could hide the fields without writing VBA code with embedded SQL strings. If this is the case, please let me know so I can give you some pointers.

Regards

Stephen