I used this in a query
Code:
SELECT Field.Field_Name, System.[System Name], [Nomenclature] & " " AS Nomen, Component.Component, Version.Version, Accreditation.[ACC_#], Accreditation.Expires, Accreditation.Compliance, Accreditation.FD_Compliant, Accreditation.Type_ACC, Accreditation.Accred, Main.Hold
FROM Version RIGHT JOIN (System RIGHT JOIN (Nomenclature INNER JOIN (Field INNER JOIN (Component INNER JOIN (Accreditation INNER JOIN Main ON Accreditation.Accred_ID = Main.[ACC_#]) ON Component.Comp_ID = Main.Comp_ID) ON Field.Field_ID = Main.Field_ID) ON Nomenclature.Nomen_ID = Main.Nomen_ID) ON System.SYS_ID = Main.SYS_ID) ON Version.Vers_ID = Main.Vers_ID
WHERE (((Field.Field_Name) Like "*" & [Forms]![Search]![Field] & "*") AND ((System.[System Name]) Like "*" & [Forms]![Search]![System] & "*") AND (([Nomenclature] & " ") Like "*" & [Forms]![Search]![Nomenclature] & "*") AND ((Component.Component) Like "*" & [Forms]![Search]![Component] & "*") AND ((Version.Version) Like "*" & [Forms]![Search]![Verion] & "*") AND ((Accreditation.[ACC_#]) Like "*" & [Forms]![Search]![ACC_Number] & "*") AND ((Accreditation.Expires) Like "*" & [Forms]![Search]![Expiration] & "*") AND ((Accreditation.Compliance) Like "*" & [Forms]![Search]![Expired] & "*"));
With this form:
Into a report