I am updating an old Access application with a backend sql server.
In a report, I have a subreport based on a very complex query. I would like to run the data source as a pass-thru query.
When I do, I get this error:
"You cannot use a pass-through query or a non-fixed column crosstab query as a record source for a subform or subreport."
It also says that I need to specify the column...