Hi All,

I have a crosstab query which one of the fields (FY) has criteria to limit the data to (13, 14, etc.). This field doesn't show up on the report...only designed to filter data from a certain fiscal year. I'm trying to use this field in my report title, but have not had success. In other reports that use simple queries, I have been able to do it by using the DLookup or Dmax functions, but when I try that with the crosstab query, I get #Name? returned instead of the data in the FY field. What's the secret to get this to work? Thanks.