HELP - query question

[Guest]

I am trying to create a query.
I would like the output to look like this in 17 columns:
Name N_name1 N_name2 N_name3 ... N_name16
John ten twenty thirty ... onehundredsixty
Jane thirty fifty twenty ... ten

I have 3 tables. the first looks like this with 17 colums:
Name N1 N2 N3 ... N16
John 10 20 30 ... 160
Jane 30 50 20 ... 10

the second and third look like this with 2 columns
N N_name
10 ten
20 twenty
30 thirty
40 forty
50 fifty

These 2 tables could be combined, but this is how they are right now.

The relationship connects the N to N1,N2,N3,...,N16

Can anyone help? I would really appreciate it.

Thanks in advance

 

[Duane Hookom]

At least one reply in an earlier thread.