Names in an Expression

[Elizabeth Reynolds]

I need to put first and last names in an expression. I have done this but
how do I put a space between the names?

 

[Duane Hookom]

[First Name] & " " & [Last Name]

 

[Elizabeth Reynolds]

Thanks for the help.

Now, I need to sort by the last name that is in an expression that consists
of first name and last name. Can you help me with this?

[First Name] & " " & [Last Name]

--
Duane Hookom
MS Access MVP

I need to put first and last names in an expression. I have done this but
how do I put a space between the names?

 

[PC Datasheet]

Include both Duane's expression and the Last Name field in your query. Sort
on Last Name.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

Thanks for the help.

Now, I need to sort by the last name that is in an expression that
consists
of first name and last name. Can you help me with this?

[First Name] & " " & [Last Name]

--
Duane Hookom
MS Access MVP


in
message news:[email protected]...

I need to put first and last names in an expression. I have done this
but
how do I put a space between the names?

 

[Ofer]

Select [First Name] & " " & [Last Name] as FullName ,[First Name] , [Last
Name] From TableName Order By [Last Name]

--
I hope that helped
Good luck

Thanks for the help.

Now, I need to sort by the last name that is in an expression that consists
of first name and last name. Can you help me with this?

[First Name] & " " & [Last Name]

--
Duane Hookom
MS Access MVP

I need to put first and last names in an expression. I have done this but
how do I put a space between the names?

 

[Elizabeth Reynolds]

For some reason I cannot get this to work.

Select [First Name] & " " & [Last Name] as FullName ,[First Name] , [Last
Name] From TableName Order By [Last Name]

--
I hope that helped
Good luck

Thanks for the help.

Now, I need to sort by the last name that is in an expression that consists
of first name and last name. Can you help me with this?

[First Name] & " " & [Last Name]

--
Duane Hookom
MS Access MVP


message I need to put first and last names in an expression. I have done this but
how do I put a space between the names?

 

[Ofer]

What are the names of the fields (first and last name) and the name of the
table

--
I hope that helped
Good luck

For some reason I cannot get this to work.

Select [First Name] & " " & [Last Name] as FullName ,[First Name] , [Last
Name] From TableName Order By [Last Name]

--
I hope that helped
Good luck

Thanks for the help.

Now, I need to sort by the last name that is in an expression that consists
of first name and last name. Can you help me with this?

:

[First Name] & " " & [Last Name]

--
Duane Hookom
MS Access MVP


message I need to put first and last names in an expression. I have done this but
how do I put a space between the names?

 

[Duane Hookom]

Sorting your query may not have any effect on the sorting in your report.
Open the report's sorting and grouping dialog and set the expression to:

[LastNameField]

--
Duane Hookom
MS Access MVP

What are the names of the fields (first and last name) and the name of the
table

--
I hope that helped
Good luck

For some reason I cannot get this to work.

Select [First Name] & " " & [Last Name] as FullName ,[First Name] ,
[Last
Name] From TableName Order By [Last Name]

--
I hope that helped
Good luck


:

Thanks for the help.

Now, I need to sort by the last name that is in an expression that
consists
of first name and last name. Can you help me with this?

:

[First Name] & " " & [Last Name]

--
Duane Hookom
MS Access MVP


"Elizabeth Reynolds" <[email protected]>
wrote in
message I need to put first and last names in an expression. I have done
this but
how do I put a space between the names?