Ok I have an Access database and want to know if it is possible to set up drop downs in Access to do some quick analysis? For example in the attached database Im trying to set up a drop down to get a count of patients by PCP for a particular month.
I know this can be down in Excel but my company is in love with Access.
Thanks!
Day92;
There is nothing attached. If you have an .mdb or an .accmdb file, you need to zip it before uploading it.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
Alan - I could not get it to upload but here is a text file of the data. Does my request make sense?
I think that the easiest way to do this is to create an aggregate query that is Grouped by the PCP and a count of the Patients. To do this, you will need to create a query in the QBE. Bring in your table. Select the PCP field and the patient field. Select the Sigma at the top of the Screen. It is the Greek letter that resembles an E. Change the Group By for the Patients to Count. This should give you a count of patients grouped by PCP. This can then be exported to Excel or be the recordset for a printed report if that is the direction you wish to go. If you were looking for something different, post backk with more information.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks