SQL help, joining tables

I have the following code:

VB 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.

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

should work fine.....or if you wanted to format to currency

cpm = Format(rs2.fields("f.cost_per_meter"), "Currency")

Code:

---

cpm = rs2("cost_per_meter")

---

The name of the table is not included in the name of the field.

hrm getting "Either EOF or BOF is true, or record deleted..." error

ah nm something is wrong it my sql statement

Got it working thanks for the help :)