Need some help. This is a sub report that works in the report.
SELECT mt_Inventory.I4206 AS SerialNumber, mt_Inventory.I4201 AS CustomerID, mt_Inventory.I4202 AS Manufacturer, mt_Inventory.I4203 AS [Model Number], mt_Inventory.I4204 AS Description, mt_Inventory.Room, mt_Inventory.Location, mt_Inventory.I4218 AS Dept
FROM mt_Inventory
WITH OWNERACCESS OPTION;
But when I replace mt_Inventory.I4201, with mt_Inventory.IDOverride. It doesn't show on the report. IDOverride is part of the table, HOWEVER, I'm thinking
SELECT mt_Inventory.I4206 AS SerialNumber, mt_Inventory.IDOverride AS CustomerID, mt_Inventory.I4202 AS Manufacturer, mt_Inventory.I4203 AS [Model Number], mt_Inventory.I4204 AS Description, mt_Inventory.Room, mt_Inventory.Location, mt_Inventory.I4218 AS Dept
FROM mt_Inventory
WITH OWNERACCESS OPTION;
IDOverride is part of the table, HOWEVER, I'm thinking the reason why it's not showing that subreport is because there's null values. There are some values under IDOverride, but there not all filled out.
So I thought something like =IIf(IsNull([IDOverride]),[I4201],[IDOverride]) would work in the criteria. But that failed too.
Thanks for the help