Main table: [DataTable]
Table of files: [FileTable]

I want to use Left([FileTable].[FileName],6) as the criteria in a query of [DataTable].[IDNo] and print the report [rpt FILE NAME] for the desired [IDNo].

Can this be done using code, i.e., QueryDefs?

Thanks.