I'd like to have this population logic built in an Access database

I have the "mapping" table in Column Start, End, Bucket), then have the values in (My Values) column. I can populate the bucket for (My values) column in excel easily via vlookup, but want to be able to do the same via Access.

The Only solution i can think of is a loft of IIF () function, but that's messy and not classy.

Cheers for your help in advance.

All the Best,
Granady



EDIT: These are two seperate tables. Start/End/Bucket is Table1
and Table2 is where i have "My values", and where i would want the Bucket to be populated based on Table1 values.

    

    Start	End	  Bucket		My values			Bucket (populated via vlookup)
    0.00	0.08	1			7.416438356			22
    0.08	0.16	2			7.416438356			22
    0.16	0.25	3			7.416438356			22
    0.25	0.33	4			7.416438356			22
    0.33	0.41	5			0.252054795			4
    0.41	0.49	6			0.750684932			10
    0.49	0.58	7			0.504109589			7
    0.58	0.66	8			0.504109589			7
    0.66	0.74	9			0.504109589			7
    0.74	0.82	10			9.690410959			22
    0.82	0.90	11			0.504109589			7
    0.90	0.99	12			0.504109589			7
    0.99	1.23	13			0.706849315			9
    1.23	1.48	14			0.504109589			7
    1.48	1.73	15			1.504109589			15
    1.73	1.97	16			0.567123288			7
    1.97	2.22	17			0.504109589			7
    2.22	2.47	18			0.753424658			10
    2.47	2.71	19			85.56164384			24
    2.71	2.96	20			1.482191781			15
    2.96	5.00	21			2.994520548			21
    5.00	10.00	22			3.594520548			21
    10.00	25.00	23			99			        24
    25.00	101.00	24			0.504109589			7