How To Use Concatenation In Access To Create A Custom Lookup

It's a mouthful to pronounce but CONCATENATION in Access is a really useful feature when it comes to combining data. This article describes how to use concatenation to create a custom lookup for use in a Combo control by using a query to combine fields from an existing staff table. The Combo lookup to be used in another table is to show complete staff names in the pop down list.

The full article appears here:
http://www.microsofttraining.net/article-1616-how-use-concatenation-in-access-create-custom-lookup.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com