ekendricks
Posts: 34
|
Posted: 06/17/2004, 1:32 PM |
|
In my customer table, I have the customer name seperated into three fields, (LName - FName - MI) In a non-edit grid or label I would like to show the customer name as one value. I'm familiar with the string to do this (SELECT Patient.PatientID, Patient.[FName] & " " & [MI]&" "&[LName] AS Patient
FROM Patient;) My question is, where in CC do I alter the sql stmt to accomplish this. I have tried Properties > Data Source to no avail. I cannot edit the sql in the Query Builder.
Any suggestion would be appreciated.
Thanks
ELK
|
|
|
E43509
Posts: 283
|
Posted: 06/17/2004, 2:05 PM |
|
Lots of ways to do this. You can change the datasource to sql and write you statement. Add a new field to your form and change the control source to database expression, add a before show code to concatenate the data, ...
|
|
|
andrewi
Posts: 162
|
Posted: 06/19/2004, 4:24 AM |
|
Or you can leave the datasource as it is,
Change the customer name label Control Source Type to Database Expression, and put your expression [FName] & " " & [MI]&" "&[LName] straight into the Control Source property.
|
|
|
|