Hot answers tagged

1

Create a separate report for "All months": Duplicate the existing report. In the new report, remove the prompt and filter.


1

Since the prompt is coming of the criteria for the query itself, then you need to modify the query, not the report. Using Is Null and Is Not Null in a new expression you can tell Access to either use the given criteria or return all records. Copy your criteria and paste it in the top Field of a new column (Note: you do not need to include the Expr1: ...


1

It will connect to whatever is in the connection string, so changing the the Source there will accomplish the goal of having it use the new Access file. The downside, is that the connection file doesn't change to match the new source and will still show the old Access file which may cause confusion later.



Only top voted, non community-wiki answers of a minimum length are eligible