Yes, the added column appears in design view of the report. Our ERP software actually uses Access as it's main interface to generate reports. In order to edit anything in the mdb files you open up the ERP software in Admin mode and at the same time it opens access.

Once I have the ERP software compile the MDB files, and open the ERP software in normal user mode, make a call to generate the report, my added data comes back with an error....

I'm saving it in Access. The Access files our used by our ERP software to generate reports. When something is changed in the Access files the software requires you to compile the mdb files.

Did I go about modifying the query correctly? I'm just wondering if typing in the new field I wanted and then saving (closed it and it asked me if I wanted to update the recordsource) was the right step to take. After I did add it in the query,...

I am pretty new to editing things in vba access. I have a report that didn't have a field that I needed in the field list, I modified the recordsource query, it is a sql pass through query:
SELECT dbo.SalesOrderD elivery.SOD_Rec ordID,dbo.Sales OrderDelivery.S OD_UserDef1,dbo .SalesOrderDeli very.SOD_UserDe f2, dbo.SalesOrder. SOM_SalesOrderI D, dbo.SalesOrderl ine.SOI_Packsli pDesc,dbo.Sales Order.SOM_Speci alInst, dbo.SalesOrderL ine.SOI_SOLineN br, dbo.SalesOrderD elivery.SOD_Req uiredDate,...