Forum home » Delegate support and help forum » Microsoft Access Training and help » Access - Null Values
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access - Null Values
Resolved · High Priority · Version 2003
Reply Thu 24 Apr 2008, 13:11Delegate Claire said...
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.
For upcoming training course dates see: Pricing & availability
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
|