Access Report Record Source Change

[Vittles]

I have an access 97 converted to access 2000 employee database. I have a report set up that can pull/query employee hire dates by the year they were hired, what I want to have a user be able to do is to pull either by year or if she doesn't enter a year to have the report pull all of the records. I tried working with the showallrecords command, but it failed due to this being a converted database from 97. Any other ideas on how to do this (without having to set up 2 different reports one for pulling by year & one that pulls all employees)?

 

[ConnellG]

Here's one way to accomplish what you want.

1. Create a parameter for the Year field in your query, such as: [Enter Year] Show is checked.

2. Open a blank field in the query called [Enter Year]
In the 'criteria' row type Is Null
In the 'or' row type Is Not Null
Show is not checked.

Reference Microsoft Knowledge Base: Q103181

 

[Vittles]

Thanks - that put me on the right track. I ended up entering an Or: [Enter Year:] Is Null under the criteria of [Enter Year:] so that if the the year isn't filled in as a query parameter it will pull all. Wildcards didn't work - like I had initially hoped. Thanks again.