<div>
If you are in SQL view try<br />
<br />
last_name &amp;&nbsp;&quot;, &quot;&nbsp;&amp; first_name as [name]<br />
<br />
however, I would recommend NOT using a reserved word as a field name. Try &quot;fullname&quot; instead of &quot;name&quot;.
</div>


If you are in SQL view try

last_name & ", " & first_name as [name]

however, I would recommend NOT using a reserved word as a field name. Try "fullname" instead of "name".

<div>
Poor choice of identifiers on my part. &nbsp;&quot;name&quot; is not what I am using, but something else. &nbsp;My query is much more complicated than this (multiple tables). &nbsp;What I really need to know is whether or not I can do this kind of an operation from a query?<br />
<br />
Thanks..Tom
</div>


Poor choice of identifiers on my part.  "name" is not what I am using, but something else.  My query is much more complicated than this (multiple tables).  What I really need to know is whether or not I can do this kind of an operation from a query?

Thanks..Tom

<div>
Problem could be that some fields are empty:<br />
<br />
full_name: IIf(last_name+first_name Is Null, Nz(last_name &amp;&nbsp;first_name, &quot;Unknown&quot;),last_name &amp;&nbsp;&quot;, &quot;&nbsp;&amp; first_name)<br />
<br />
/gustav
</div>


Problem could be that some fields are empty:

full_name: IIf(last_name+first_name Is Null, Nz(last_name & first_name, "Unknown"),last_name & ", " & first_name)

/gustav

<div>
<div class="content wysiwyg-content">
I have an access 2007 application that has a person table, with last_name, first_name attributes. &nbsp;I would like to build a query where I can combine last_name and first_name, and represent the combined fields as one field &quot;name&quot;. &nbsp;I have tried the following:<br />
<br />
name:last_name &amp;&nbsp;&quot;, &quot;&nbsp;&amp; first_name<br />
<br />
but I get syntax errors from SQL.<br />
<br />
Is there a way to do this?<br />
<br />
Thanks in advance for your help.<br />
<br />
Tom
</div>
</div>


I have an access 2007 application that has a person table, with last_name, first_name attributes.  I would like to build a query where I can combine last_name and first_name, and represent the combined fields as one field "name".  I have tried the following:

name:last_name & ", " & first_name

but I get syntax errors from SQL.

Is there a way to do this?

Thanks in advance for your help.

Tom

Combining table fields within a query

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.