Access - Null Values

The UK's most regular instructor-led training courses.
Training information: access vba · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · High Priority · Version 2003

Claire has attended:
Excel VBA course

by - delegate Claire [2 posts] (2008 Apr 24 Thu, 13:11) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Access - Null Values

by - trainer Stephen gold contributer [369 posts] (2008 May 9 Fri, 10:56) Reply

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

· Three Myths About Microsoft Access
· Microsoft Access Mistakes to Avoid
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Access VBA Handling Errors and Debugging Code
· MS Access: Access your Personal Information with Ease

Please browse our web site to find out more about
access vba and other Microsoft training courses.

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips