The WHERE condition in the following code is producing a blank report with no data. How can this possibly be? Note that JobID is an integer field in the report's recordsource.
DoCmd.OpenReport "rptProductionOrder", acViewPreview, , "JobID = 10"
********** PROBLEM SOLVED ************
Underlying query for the report had an inner join instead of a left join, which restricted available records .... I feel foolish![]()