Hi,
I am creating a report that will show company contact information and I want to be able to filter it by the person's age. The person's age does not show up on the report but I want to have the user select from three option boxes whether they want to view all "Junior Members" (anyone under the age of 18 at the running of the report), all "Senior Members" (anyone over the age of 18 at the running of the report), or all members regardless of age. I have looked and researched all over the internet for an solution to my problem and I just can't seem to make sense of anything or find what I am looking for. In short, what I am trying to do is this: the user clicks on a reports button on a form and it brings up another form that has option buttons for all the forms they can run. Right now I am just working on the report for member contact information. So what would happen when the user gets to this reports screen is they go and select the junior member, senior member, or all member option button and hit run. The program will then, using VBA code, filter the data based on the given parameters that I explained above and spit out the report with the data as filtered.
The only other piece that I want to include if possible pertains to the reports that contain all member contact information. I want the report to run and display all contact information for all members with the added piece that I want it to sort the member information data, if possible, by whether or not the member is a junior or senior member. I hope that all of this makes sense but please feel free to ask for more clarification on my question.
I am creating a report that will show company contact information and I want to be able to filter it by the person's age. The person's age does not show up on the report but I want to have the user select from three option boxes whether they want to view all "Junior Members" (anyone under the age of 18 at the running of the report), all "Senior Members" (anyone over the age of 18 at the running of the report), or all members regardless of age. I have looked and researched all over the internet for an solution to my problem and I just can't seem to make sense of anything or find what I am looking for. In short, what I am trying to do is this: the user clicks on a reports button on a form and it brings up another form that has option buttons for all the forms they can run. Right now I am just working on the report for member contact information. So what would happen when the user gets to this reports screen is they go and select the junior member, senior member, or all member option button and hit run. The program will then, using VBA code, filter the data based on the given parameters that I explained above and spit out the report with the data as filtered.
The only other piece that I want to include if possible pertains to the reports that contain all member contact information. I want the report to run and display all contact information for all members with the added piece that I want it to sort the member information data, if possible, by whether or not the member is a junior or senior member. I hope that all of this makes sense but please feel free to ask for more clarification on my question.