MS ACCESS SUMMISING DATA IN ACCESS

[JACS01]

Hope you can help me
I have two tables

Table 1
ID Number (Unique primary key)
Customer name
Question Number
Satisfaction Score
Importance score
Comments

Question lookup
Code (Unique primary key)
Question number
Question group

I am wanting to run a summary query which tells me
By question group the average,min,max satisfaction score

I currently have a relationship line set up between question Number in Response 2003 and question lookup.

so far I have the following fields in the query
Question group (grouped by) (from the question lookup table)
Satisfaction (Minimium) (From the repsonse 2003 table)
Satisfaction (Maximium) (From the repsonse 2003 table)
Satisfaction (average) (From the repsonse 2003 table)

But the query above returns no values (I have data in both tables)

Please help
Jac

 

[Norie]

What type of relationship is it?

It should be one to many from Question lookup to Response 2003 (Table1?)

 

[JACS01]

Sorry table one is response 2003

The relationship between the two tables is a one too many.

In question lookup the a question will appear once
In Response 2003 the question will appear more than once.