Inner Join for this ?

I had help doing his query and it works but now I need to create an actual field from this query

My query joins two fields, Last_Name and First_Name

SELECT [Participants].[First_Name]+' '+[Participants].[Last_Name] AS Full_Name
FROM Participants
ORDER BY [Participants].[First_Name]+' '+[Participants].[Last_Name];

Now I need to have the Full_Name relate to the correct name in First_Nme and Last_Name fields in the db, so when I scroll through the Last_Name and First_Name via a DataControl the corresponding Full_Name is shown.

Since the AS Full_Name is a query, it does not show up automatically under the Full_Name field in the db. If this can be done so as the correct names correspond, that would be great.

Thanks in advance.

this is not join at all..when you are speaking of Join...you should speak about tables joining NOT fields...I don't think there is a name of fields joining.

anyway what's your problem? cuz you seem to have it figured it out..

just link you datacontrol onto your query and everything should works out...