I'm just new to access and have to build a database concerning my clients transanctions. I have numerous clients with numerous transaction on a wide range of dates. All my data has been entered into tables and I've got a report already with all my clients transactions and what days they happened on. Now, the problem is, I want to build subreports for each client. And the way I want a user to access these reports is have an initial screen pop up in my database asking the user for a clients name and what range of dates of transactions the user would like to look at (for example a user wants to look at all the transactions for John Doe from May 1, 2001 to August 18, 2001)
Any tips on how to do this.