I'm trying to use a SQL string to set the recordsource of a report. I am using an Access front end and a SQL Server backend.
I don't have any linked tables, so I need to reference the connection string right in the SQL string somehow . . . is this possible?
If not how can I set the recordsource of a report when I don't have any linked tables? Other than using query objects . . .
Thanks in advance . . .