beetle3247 0 Report post Posted October 21, 2020 I'm wondering if a report query can be structured so as to prompt me for filter values whenever I run it. I am doing an analysis of my database, which contains more than 29,000 names, to help analyze when my surname's DNA ended up in another surname's DNA. We think there was some hanky-panky going on back in the late 1800s and we're attempting to narrow it down to when both families were in the same area. The problem being that I need to run multiple reports with different filters for birth location and census location, etc. and I would like to not have to keep changing the query filter for the next report. If it could prompt me for the filter value then it would make life a whole lot simpler. And, it would help in the future when I help others. Thanks for any help. Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted October 21, 2020 Sure. Enter "[?]" (no quotes) into the value field to make a report definition that prompts you. Checking [Help] for any selected list report would have given you this answer. Share this post Link to post Share on other sites
beetle3247 0 Report post Posted October 21, 2020 Thanks. Sometimes I forget about the Help. Worked fine. Share this post Link to post Share on other sites
