Getting min values via sql

[salvelinus]

A coworker has an Access table named HCOM set up like so:
Code - text, three letter client code
Question - text
Module - text
Value - double

and another table named Client set up:
Code - text, three letter client code
Name - text, client name matching the code

In HCOM, there's an entry for each client code for each question and module if that question is asked for that module, and these entries have a value entry. So some entries might look like this:

[U]Code[/U]    [u]Question[/u]   [u]Module[/u]   [u]Value[/u]
ABC        Q1         A        0.0
ABC        Q2         B        2.6
ABC        Q5         D        0.0
XYZ        Q1         A        0.0
XYZ        Q2         B        1.7
XYZ        Q4         C        0.6

I want a query that will return the minimum values, including duplicates if necessary, for each question, preferably matching code with client name from the Client table, results from above would be:

[U]Code[/U]    [u]Question[/u]   [u]Module[/u]   [u]Value[/u]   [u]Name[/u]
ABC        Q1         A     0.0      A Best Crew
XYZ        Q1         A     0.0      X You Zay
XYZ        Q2         B     1.7      X You Zay
XYZ        Q4         C     0.6      X You Zay
ABC        Q5         D     0.0      A Best Crew

Thanks.