Table and Query meshing with calculated fields

[Rhubie]

I have Table A which has the following data which was imported from Excel from a Quickbooks file

01-M0011


01-M0012
01-M0013
01-M0014

01-M0021
01-M0022
01-M0023
01-M0024

Table B - Access Table that has:

01-M0011
01-M0021

I have a query that does calculations on the data from Table B

	Book Price	BookHalfPack Price	BookPack Price	Pack Price
01-M0011	42.75	40.25	37.75	754.60
01-M0021	43.40	40.90	38.40	768.40

I need to get the prices into the Table A (or another query)

01-M0011	42.75
01-M0012	40.25
01-M0013	37.75
01-M0014	754.60
01-M0021	43.40
01-M0022	40.90
01-M0023	38.40
01-M0024	768.40

I did set up a field in Table A that has values of 1, 2, 3, 4 and thought that I could do an IIf statement, but I don't know how to match - or if I could put the 01-M0011 into a variable and then use the 1,2,3,4 to match. If 1 then Book, 2 then BookHalfPackPrice, 3 then BookPackPrice, 4 then packprice - but I don't know how to connect to the right book, bookhalfpackprice, etc.

[Rhubie]

Any suggestions - on how this can or cannot be done