COST PER MILE REPORT

[ria]

Select mileage.TruckID, mileage.MONTH, mileage.YEAR,
mileage.MILES, [Cost Per Month].AMOUNT, [Cost Per
Month].AMOUNT/mileage.MILES AS [Cost Per Mile] from
[mileage], [Cost Per Month] where mileage.TruckID = [Cost
Per Month].TruckID and mileage.MONTH = [Cost Per
Month].MONTH and mileage.YEAR = [Cost Per Month].YEAR;

should do the trick....