combine two or more fields in access

[Roadwarrior1]

I am trying to combine two or more fields in access query to display (Smith,
J. K.) in one field. I have all three fields in my tables but the first and
last names are spelled out. How can display only the first character in each
name?

 

[boblarson]

In a query you can use

AbbrevName:[LastName] & ", " & Left([FirstName],1) & ". " &
Left([MiddleName],1)

Be sure to substitute the parts in square brackets with your actual field
names AND remember to KEEP the square brackets.

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[boblarson]

Oops, forgot the last period:

AbbrevName:[LastName] & ", " & Left([FirstName],1) & ". " &
Left([MiddleName],1) & "."

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

In a query you can use

AbbrevName:[LastName] & ", " & Left([FirstName],1) & ". " &
Left([MiddleName],1)

Be sure to substitute the parts in square brackets with your actual field
names AND remember to KEEP the square brackets.

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

I am trying to combine two or more fields in access query to display (Smith,
J. K.) in one field. I have all three fields in my tables but the first and
last names are spelled out. How can display only the first character in each
name?

 

[Roadwarrior1]

Thanks this was a big help. It works great.

Oops, forgot the last period:

AbbrevName:[LastName] & ", " & Left([FirstName],1) & ". " &
Left([MiddleName],1) & "."

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

In a query you can use

AbbrevName:[LastName] & ", " & Left([FirstName],1) & ". " &
Left([MiddleName],1)

Be sure to substitute the parts in square brackets with your actual field
names AND remember to KEEP the square brackets.

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

I am trying to combine two or more fields in access query to display (Smith,
J. K.) in one field. I have all three fields in my tables but the first and
last names are spelled out. How can display only the first character in each
name?