D Douglas J. Steele Jul 18, 2004 #2 John C. said: Is it possible to set the Report Record Source to an SQL statement? Click to expand... Yes is is. When you create the report, don't select an existing table or query when prompted. When the new report opens in Design mode, paste the SQL statement into the RecordSource property.
John C. said: Is it possible to set the Report Record Source to an SQL statement? Click to expand... Yes is is. When you create the report, don't select an existing table or query when prompted. When the new report opens in Design mode, paste the SQL statement into the RecordSource property.
