Paeter most of my issue wasn't coding at all. My database contains both consumed and produced product. I only wanted to add consumed and ignore the produced.

Armed with that information I kicked it's ass and now have it adding what I want.

Appreciate you taking the time to whisper sweet nothings in my ear!

What do you suggest the best way to put this data in to a database so I can use it to compare against another database?

I will need to check for type of wood and thickness and then pull that value to multiply by.

 
CREATE TABLE wood_costs
( species VARCHAR(30) NOT NULL
, thickness TINYINT NOT NULL
, cost      SMALLINT DEFAULT NULL
);
 
INSERT INTO wood_costs ('Red Oak',3,85);
INSERT INTO wood_costs ('Red Oak',4,85);
...
INSERT INTO wood_costs ('Hard Maple',7,135);
...
INSERT INTO wood_costs ('Other Hardwood',16,285);
 

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="KilnData">
      <DataSourceReference>KilnData</DataSourceReference>
      <rd:SecurityType>None</rd:SecurityType>
      <rd:DataSourceID>0915e801-0c00-4013-a86a-3762972008de</rd:DataSourceID>
    </DataSource>