Report Record Source

D

Douglas J. Steele

John C. said:
Is it possible to set the Report Record Source to an SQL
statement?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top