ms Access Query

I have a simple query with two tables. One table named List has a complete list of currency values and the other table MinMax contains a minumum
value (currency) and a maximum value (currency).
When I query the complete List with Between 352.00 and 398.46
for instance everything works.
But when I query the complete table List with
Between MinMax.Min and MinMax.Max it does not work.
How can I query one table with values from taken from another?

This statement should work

SELECT values.CurValues
FROM [values], MinMax
WHERE (((values.CurValues) Between [minmax].[min] And [minmax].[max]) AND ((MinMax.PKey)=2));


I added a PKey field to my variation of MinMax so the the Select statment would know which record to use.

If you need I can send you a sample DB where this works.
s-

Its nice to know that its possible. I thought that it would be.
I am working on this.
Sending me a sample database would be more that I would expect but that would be a real help to me at this time.
Thank you very much if you can do that.
Bill

Here is the Sample DB

This worked perfectly. Thanks Very Much/
If I can do something for you let me know. Just email me and I
will contact you back.
Just a note.
I took this job from a local businessman who had a developer hired to build his database. This developer could not accomplish this task either and after a lengthy period gave up on it.
I do a lot of online database work and I think I could have done this in Cold Fusion or PHP but the businessman wanted the job inside his Access application.
Thanks again.
Bill