null field in query (1 Viewer)

$lim

Registered User.
Local time
Yesterday, 19:09
Joined
Dec 14, 2004
Messages
21
i am creating a DB for all the software installed on PC's i have a table that if a certain software is installed i would enter the version number, and if it is not installed then i would just leave it blank. How can i create a query that will disregard all the null fields (meaning that software is not installed on that specific pc) and jsut show the records that have a version number in it. I am almost positive there is a setting for this, i just can't find it, don't think you have to put some kind of code behind this to create the query. Any help would be much appreciated.
 
Local time
Yesterday, 16:09
Joined
Aug 2, 2004
Messages
272
Sample query:

SELECT
My_Table.A

FROM
My_Table

WHERE
(((My_Table.A) Is Not Null));

HTH :cool:
 

Users who are viewing this thread

Top Bottom