I have the report fully formatted just as I want it, but it now requires data that is not available from the Query that was used to create it. I want to find the place to change the data source to a different query and cannot see it anywhere.
I have the report fully formatted just as I want it, but it now requires data that is not available from the Query that was used to create it. I want to find the place to change the data source to a different query and cannot see it anywhere.
That is the RecordSource property. This property can reference a table or query object or can be an SQL statement. Click the ellipsis (...) to open the query builder to edit query object or SQL statement.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I found it by right clicking on the top left corner of the report in design mode, then selection "report properties". I don't know why something so basic is so hidden. Anyway, consider this one solved.