If the FirstName and LastName field aren t actuall
Joe Beniacar
10 years ago
If the FirstName and LastName field aren t actually on the ContactLetterR, where is the concatenated field FullName obtaining it s data from? Is the Report s Record Source like a Query s Table or the Query fields you bring into the Field: row to make calculated fields off of (even if you don t bring them into the Report directly)?
Reply from Alex Hedley:
ContactLetterR has a RecordSource of ContactForLetterQ ContactForLetterQ is a Query using two Tables: CustomerT and ContactT. CustomerT has both FirstName and LastName
There is a Textbox on the Report called: FullName that has a Control Source of :=[FirstName] & " " & [LastName]
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.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 5.