If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need null values for several fields in db
I have an equipment inventory db. I need to run a query that would give me
the records that contain null values in several of the fields. I have run a successful query to return records that have a null value in one field but don't know how to combine so that query returns records that also have null values in other fields or any other fields. Please advise -- dmp |
#2
|
|||
|
|||
Need null values for several fields in db
You join the seperate queries with a UNION.
SELECT * From YourTable WHERE YourField Is NULL UNION SELECT * From YourTable WHERE YourField2 Is NULL UNION SELECT * From YourTable WHERE YourField3 Is NULL ; You can't do this from the normal query grid. Rather you probably need to do it in the SQL view typing in something like above. One big point he If you have to do things like this, there's a very good chance that your data isn't properly normalized and your tables set up less than optimum. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "shahnaz" wrote: I have an equipment inventory db. I need to run a query that would give me the records that contain null values in several of the fields. I have run a successful query to return records that have a null value in one field but don't know how to combine so that query returns records that also have null values in other fields or any other fields. Please advise -- dmp |
Thread Tools | |
Display Modes | |
|
|