SQL help, joining tables

[Graff]

I have the following code:

rs2.Open "SELECT f.cost_per_meter, fu.length_used FROM fabric f, fabricused fu WHERE f.fabricno = fu.fabricno AND fu.garmentno = " & garmentid, conn

Now how would I put cost_per_meter/len_used in to a variable, I've tried

cpm = rs2!f.cost_per_meter
cpm = rs2.fields("f.cost_per_meter).value

and a few other variation to no avail... can anyone help me out here.