maksymilian
New Member
I am very new to MS Access and yet have been working (loosely) on a DB for a while. We have a DB that tracks membership. There is a table with all of the member info in there. When new and current customers are added, or pay for the current year, the info is applied to a 'PaidYear' column. For years now, I have been adding a query listing the current years' members and adding a report that displays the output of the query.I would like to create a report where I could (using a drop-down maybe) select the active year and other options such as City, Company Name, Phone Number, etc. Is there any way to simply set this up? It has to be easy enough for my replacements to intuitively use. ie:Member Report for [Choose Year] <-- Dropdown[City] [Company] [Phone] [Select Option]<--- Extra Options for reportingI have been playing with it for a while and while I can get the design set up, I can't set up the functionality. Thank you so much!!!