I have been following the ABCD seminar because it covers almost everything that I want to create in my project. Meat and potatoes...I concantenate people names with prefix and suffix into a PersonT from HelperT and HelperTypeT to PrefixID and SuffixID. I want to concantenate both pre- and suf- fixes into a complete display name, instead of the ID number. I think I saw it in one of the other lessons somewhere, but can't remember where. How do I do this.
Null Math may also come in handy if you are missing a prefix or suffix.
Stewart MahiaiOP 14 months ago
To be specific, I create a Person in the PersonT via PersonF... PrefixID, FirstName, MiddleName, LastName, SuffixID, PersonTypeID.
I then pull that Person (PersonID) into the EmployeeT as a concantenated name in a Combo box.
My expression is LFM: [PrifixID] & " " & [LastName] & " " & [SuffixID] & ", " & [FirstName] & " " [MiddleName];
Results in "1 Mahiai 5, Stewart K"
Would like it to read "Mr. Mahiai Jr., Stewart K"
Kevin Robertson 14 months ago
Build a query with all the required Tables then you can use the Actual name instead of the ID to get the result you want.
If using a Combo Box to display the data, base the Combo Box off the Query.
If using a Text Box you can use DLookup to get the value from the Query.
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
Microsoft Access Courses.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
