What kind of query do I need?

[cowboy]

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?

[pbaldy]

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