Need Easy Report Fix

[RichB]

I tried to search because I know this is in this forum somewhere. I just did a few searches and came up empty so . . . I am asking this question. I have a form that uses the following Select statement

SELECT [Members].[PersonID],[Members].[FirstName]&", "&[Members].[LastName] FROM [Members] ORDER BY [LastName]


My problem is when I open the table this writes to; it lists the PersonID and not the FirstName and LastName as it lists in the combo box on the form. I understand why but I can't seem to modify the Select statement to put the FirstName and LastName in the the field it is writing to.


Should I be looking at the report or table properties?

Thanks
Rich

 

[FilipT]

name field

I'm not sure if I understand you correctly, but if you want to get the firstname and lastname in one field, you have to change your select statement to the following:


SELECT [Members].[PersonID],[Members].[FirstName]&", "&[Members].[LastName] As Name FROM [Members] ORDER BY [LastName]

 

[RichB]

It still populates the table with the PersonID and not the name. Im still trying.

Thanks

 

[Rich]

Storing the person ID is the correct method, the names already exist in your db and can be retrieved at any time via queries. You shouldn't normally store duplicate data.