Summing Entries in Queries

[mikediner]

I am a new user of Access and have a question (I apologize if it's already been asked):

For various reasons, I had to create one master table (Code) and relate the rest of the tables to Code with relationships (I can't just use one big table).

Let's say I have three tables then: Code, Name, Value (Name having two columns: one "code" which relates to Code and the other "name," and Value functions similarly). I want to summarize Value according to Name. But my problem comes if I have two entries for one code.

For example in Name I have:

Code Name
1 John
1 John

and in Value I have:

Code Value
1 2
1 3


Then when I use a query, I'd like to get:

Name Value

John 5

But I get:

Name Value

John 2
John 3
John 2
John 3


Any way to sum the values only when a name is repeated? And I'll want to do this with numbers and strings (so I'll need to do more than just sum numbers).

I'm assuming the answer is in SQL, but I have no experience with it.

Thanks so much for reading this and helping me out!

Michael