<p>I'm looking for an Access 2007 equivalent to SQL Server's COALESCE function.</p>

<p>In SQL Server you could do something like:</p>

<p><strong>Person</strong></p>

<pre><code>John
Steve
Richard
</code></pre>

<p><strong>SQL</strong></p>

<pre><code>DECLARE @PersonList nvarchar(1024)
SELECT @PersonList = COALESCE(@PersonList + ',','') + Person
FROM PersonTable

PRINT @PersonList
</code></pre>

<p>Which produces: John, Steve, Richard</p>

<p>I want to do the same but in Access 2007.</p>

<p>Does anyone know how to combine rows like this in Access 2007?</p>

I think Nz is what you're after, syntax is
```
Nz(variant, [if null value])
```
. Here's the documentation link:
Nz Function
```
```
---Person--- 
John
Steve
Richard

DECLARE @PersonList nvarchar(1024)
SELECT @PersonList = Nz(@PersonList + ',','') + Person
FROM PersonTable

PRINT @PersonList
```
```