K
KenN
Guest
I am trying to get the criteria of a filter into the header of a report, and have it display in a somewhat pleasing format. I put an unbound text box in the header and set the source to -- =[Reports].[rptInputFilter].[Filter] -- and that would display it as (((qryForm.AnnOrgCode="12345"))). I changed it to -- =Mid([Reports].[rptInputFilter].[Filter],12,30) -- and that changed it to -- AnnOrgCode="12345"))). I would like to get rid of the last three parentheses but don't know how.
