Hi there!
I'm relatively new to Access, but I'm currently developing a database for a charity I volunteer with that supports disabled adults and children.
I have a table which contains the following fields:
-Date of birth
-Gender
-Conditions 1/2/3
As we frequently have to report statistics based on these three areas to our funders, I was wondering how I could develop a pop-up 'search-like' form where I could search for certain information: e.g. number of male and female service users between the age of 12 and 18 with autism; or a pie chart showing the distribution of conditions for all service users aged 25 and over.
I'd hope that a report of some sort could be generated from this information and shown in a form.
I understand this might be based on queries, but also, if possible, I'd like query information to be deleted after the user finishes their search.
If anybody could offer any advice or assistance, that would be much appreciated!
Thanks!
I'm relatively new to Access, but I'm currently developing a database for a charity I volunteer with that supports disabled adults and children.
I have a table which contains the following fields:
-Date of birth
-Gender
-Conditions 1/2/3
As we frequently have to report statistics based on these three areas to our funders, I was wondering how I could develop a pop-up 'search-like' form where I could search for certain information: e.g. number of male and female service users between the age of 12 and 18 with autism; or a pie chart showing the distribution of conditions for all service users aged 25 and over.
I'd hope that a report of some sort could be generated from this information and shown in a form.
I understand this might be based on queries, but also, if possible, I'd like query information to be deleted after the user finishes their search.
If anybody could offer any advice or assistance, that would be much appreciated!
Thanks!