Discussion Locked
Acc97 - Showing query results in report
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to display a crosstab's query results in a report, without using a form. Using a form will lock in the fields that I need to display, so underlying data changes cannot be made. The query itself runs fine - but has many #Name? issues when usedwithin a form (or subreport) when values are changed because column headings (and the number of columns in the query change with the data values. Can I do this without imposing standards over the column data?