-
What kind of query do I need?
I have a table with many records. Each record has a [IDNumber], [Elevation], and an [Area] which there are 20 different possible areas.
What I want is a list of every [IDNumber] that Is Null([Elevation]) = true
but I want them grouped by area, is this possible?
Any ideas?
-
Not clear on the structure or goal, but does this work?
SELECT [IDNumber], [Area]
FROM TableName
WHERE [Elevation] Is Null
ORDER BY [Area]
Or if you're looking for one line per area, with a concatenated list of IDNumbers, you could adapt this:
Return a concatenated list of sub-record values
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules