Hope this makes sense. I have two tables, the first collects general data that for a particular home, including family name (last name), I then have a second table that collects specific information about the adults in that home including first name. What I want to do is, combine the first names with the last name so it would read Kevin & Lori <Last Name> if there is more than one adult (there would be no more than two that we would have information on). What I am getting so far is Kevin & Kevin, Lori & Lori, etc... How can I get this to work. The tables are related, so that is not the issue.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trying to combine two first name fields into one
- Thread starter Klssri
- Start date
Did you check the FAQs? Does this one help faq701-4233?
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
- Status
Similar threads
- Locked
- Question