Query preview recordsorurce report

[matrixindicator]

You can open a query, change some criteria and preview the result without saving the query. A user wants that the result of the query are visible in the report without saving the query ? I think it is required to save the changes in the query before they are visible in the report ?

 

[PWise]

instead of useing a query as the record source of the report use a select statement

 

[matrixindicator]

Select statement is in this case to large and if you write Select * he shows the query in his total.

 

[PWise]

add a where condishion to the query in the recordsource

Select * 
from Queryname
where filed0=xxxx