Access Creating names from fields in access database.


Joined
Sep 18, 2015
Messages
1
Reaction score
0
Hello I have access 2013.

In a table I have fields Title FirstName LastName

Initially I created an addtional calculated field and used the following: (""+[Title]) & (" "+[FirstName]) & (" "+[LastName])

The above works fine.

In the future however I may want to transfer to sql server back end and I don't think sql will be happy with the calculated field in that format.

The second option I came up with was to create a query which would calclate the full name (etc...).

This again works fine using: FullName: (""+[Title]) & (" "+[FirstName]) & (" "+[LastName])

I am wondering whether once applied to a large number of records will the query run very slowly with having to concanenate a large number of records?

I would apprecaite any tips or help.

Thank you

Mark
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top