Query for Last Name, First Name works except for one record

[Yecenia]

I set up an employee database to read "Last_Name, First_Name" using
expression "[Last_Name]&","&" "&"[First_Name]" within the same query. All
the records come up EXACTLY as the expression calls except for one! One
record will not show the comma, space, or first name. I'm floored... I have
no idea how that is not showing and all the 130 other records did.

The first name is "Cory". There are not space infront of it. I have tried
to delete it and type it in again. That did not work.

Is this a bug?

 

[Jerry Whittle]

What's the last name? Something like O'Toole? A single ' can mess things up.

 

[Yecenia]

I need the outcome to be Simmons, Cory

The query results show only Simmons

What's the last name? Something like O'Toole? A single ' can mess things up.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I set up an employee database to read "Last_Name, First_Name" using
expression "[Last_Name]&","&" "&"[First_Name]" within the same query. All
the records come up EXACTLY as the expression calls except for one! One
record will not show the comma, space, or first name. I'm floored... I have
no idea how that is not showing and all the 130 other records did.

The first name is "Cory". There are not space infront of it. I have tried
to delete it and type it in again. That did not work.

Is this a bug?

 

[Jerry Whittle]

Very strange indeed. I did have a problem with your expression. The " between
the & and [First_Name] would not allow it to run. I also had to remove the
first and last " which I assumed were there for display purposes.

Try this in a query:
FullName: [Last_Name] & ", " & [First_Name]

If it doesn't work, I recommend making a copy of the database file and then
doing a compact and repair. Something may be corrupt.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I need the outcome to be Simmons, Cory

The query results show only Simmons

What's the last name? Something like O'Toole? A single ' can mess things up.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I set up an employee database to read "Last_Name, First_Name" using
expression "[Last_Name]&","&" "&"[First_Name]" within the same query. All
the records come up EXACTLY as the expression calls except for one! One
record will not show the comma, space, or first name. I'm floored... I have
no idea how that is not showing and all the 130 other records did.

The first name is "Cory". There are not space infront of it. I have tried
to delete it and type it in again. That did not work.

Is this a bug?

 

[John Spencer]

Is it possible that the LAST NAME field has a trailing new line in it?

If so, the comma, space, and first name could be there, but hidden by
the height of the row or of the control.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================