Why can't I use an alisa ParentName:[LastName]&","&[FirstName] for the ParentT (get rid of the FirstName, LastName of ParentT's Column)? I tried but I'm getting a message "The specified '[FirstName]' could refere to more than one table listed in the FROM clause of your SQL statement; even though I selected StudentT in the Table. All I am trying to do is Concatenate the fields together as one. This on 03:54 on the video timer. My database built a bit different using City, State, ZipCode as a separate field. But it works!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.