Display different types of numbers for the same record

[Guest]

Access 2003: I'm trying to create a query that will display two different
types of numbers from a table. I have a tbl with numbers and a tbl with
number type they have a one-many relationship. How can I get the query to
display two different types of numbers (Type A & Type B) for the same record
on one line?

tblNumbers
uniqueid (1-M relation to another tbl of basic contact info, i.e. fname,
lname, etc)
number
type (1-M relation to the below tbl)

tblNumberType
numbertypeid
typedescrip

Goal: Name, Number-TypeA, Number-TypeB

Thanks for your help!

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.