first name and last name

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Use Access's Union query to create a mailing list from two different tables

Have you ever needed to send the same letter to people listed in two different databases? If so, you probably thought you needed to create two different mailing lists. That's not the case—you can use Microsoft Access's Union query to combine the two tables into one list. If you...

Tags: Microsoft Access, Customer Database, Databases, Microsoft Office, Mary Ann Richardson, MailingName, Last Name, First Name, database, mailing list, Microsoft Office Suite Access Tips Newsletter, Table, Union, Intern Database, Storage, Hardware, Enterprise Software, Software, Data Management, Office Suites

Technical articles 2005-08-02

Use presentation layer table sorting to achieve a better user experience

One of the most common uses of the Internet is to displayinformation in a tabular format; examples of this include: Lists of events in date order. Contents of an article. Price lists. In many of...

Tags: Scripting languages, Mice, First Name, Last Name

Technical articles 2005-01-13

Access query to combine table fields

How do I construct an Access query to combine table fieldsOpen the query in design viewIn the Lower section, in the Field of teh column where you want to display the joined fields type the formulaExampleFieldname:[First Name] & [Last Name]orFieldname:[First Name]&" " & [Last Name] (if you need space between...

Tags: acampbell@..., First Name, Last Name, Microsoft Access, software

Q&A 2004-10-06