Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC Record Source in a report
- Thread starter rushdib
- Start date
The quietest way is to attach the remote ODBC table and to build the RecordSource parameter on the attached table.
When you can't, build a query to try the SELECT statement before you use it in your Report - you'll see the records returned.
You have to create an SQL-Direct query.
Once running, either use the query as the RecordSource or copy the SQL string generated in the Record Source parameter.
When you can't, build a query to try the SELECT statement before you use it in your Report - you'll see the records returned.
You have to create an SQL-Direct query.
Once running, either use the query as the RecordSource or copy the SQL string generated in the Record Source parameter.
- Status
Similar threads
- Locked
- Question
