Hello,
I feel silly for asking such an easy question, but I can't figure out how to do this in access query design view.
I have two tables:
First table has 1 column "Score"
My second table has 3 columns: "Lower", "Upper" and "Type"
What I want, is to match the type with the score, where score is >= Lower and <= Upper
Let's say my second table is like this:
Lower / Upper / Type
0 / 4 / Bad
5 / 8 / Good
9 / 10 / Very good
and my other table contains these scores
3
6
8
9
then I want a query that says
3 Bad
6 Good
8 Good
9 Very good
Can you please tell me how I can do this in design view, and not in SQL?
Thanks very much
Mikey