Claire has attended:
Excel VBA Intro Intermediate course
Access - Null Values
I am creating a query but there are various parts of the query that will not have information inputted into the fields. Is there a way that i can display all the information but exclude the blank fields?
I know you type is not null into the criteria in a specific field but that whole record will not be displayed and i want the other parts that have information to be displayed.
RE: 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
