Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-05-2019, 11:28 AM   #1
jedder18
Just Livin the Dream!
 
Join Date: Mar 2012
Posts: 135
Thanks: 31
Thanked 9 Times in 9 Posts
jedder18 is on a distinguished road
best practice for multiple drop down flds

Client is asking for analysis of data.
Have numerous fields holding said data, most contain drop downs, some are yes/no
I start with 1 qry grabbing all client ID's with all the populated fields.
CLient is asking for a totla(e.g. languages being spoken, as well as nbr of males/females speaking said language)
other examples: geographic data, etc
I already have count queries running for each field in the table for daily use, but, client needs all together to show %....what pct race, religion...all that fun stuff.
What is best way to show this.
Tried doing a crosstab, but, seems really messy with so many fields.
Union query? dump all info into excel and let them sort it out
any suggestions?

jedder18 is offline   Reply With Quote
Old 06-05-2019, 11:35 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,459 Times in 1,440 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: best practice for multiple drop down flds

Hi. If the list of requirements is short and known in advance, you could probably stick with Access. But if the requirements depend on daily needs based on unforeseen situations, then maybe you can give them the data in Excel and let them manipulate it themselves. If the requirements are dynamic but known in advance, you could potentially create a form to dynamically create the data statistics and display it on a form or chart.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following 2 Users Say Thank You to theDBguy For This Useful Post:
jedder18 (06-06-2019), Tera (06-06-2019)
Old 06-05-2019, 02:50 PM   #3
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,892
Thanks: 38
Thanked 574 Times in 539 Posts
MajP has a spectacular aura about MajP has a spectacular aura about
Re: best practice for multiple drop down flds

I would think you can build a report with a lot of different subforms. Subform 1 would simply by counts by language. Subform 2 would be pretty group by languages and sex.
Sub 3 is group by race and percent of total. Sub 4 is religion.

MajP is online now   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
jedder18 (06-06-2019)
Old 06-06-2019, 05:22 AM   #4
jedder18
Just Livin the Dream!
 
Join Date: Mar 2012
Posts: 135
Thanks: 31
Thanked 9 Times in 9 Posts
jedder18 is on a distinguished road
Re: best practice for multiple drop down flds

I was thinking of the subforms too. Had a similar report way back when. It will be a lot of them though and trying to grab all the totals to come up with % of ex: swf in dom violence, etc
sometimes people think we have an easy button
It's a lot of data to try to mesh together.
Thanks for all the replies.
jedder18 is offline   Reply With Quote
Old 06-06-2019, 05:37 AM   #5
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 339
Thanks: 529
Thanked 24 Times in 23 Posts
Tera will become famous soon enough
Re: best practice for multiple drop down flds

If it was me, I would create a query and link the query to a pivot table in Excel (as suggested above by TheDBGuy). Pivot table is a very strong tool that can manage all you want and will give you more than Access queries do. With several drag and drop you can have different results. You can also have several charts in Excel that are based on the pivot table.
Tera is offline   Reply With Quote
Old 06-06-2019, 08:31 AM   #6
jedder18
Just Livin the Dream!
 
Join Date: Mar 2012
Posts: 135
Thanks: 31
Thanked 9 Times in 9 Posts
jedder18 is on a distinguished road
Thumbs up Re: best practice for multiple drop down flds

I'm thinking Excel is best way to go here too.
Way too many fields to query on if they need analysis between 2 and 3 at a time.

Thanks for reply.

jedder18 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Users Of Front-End DB - Best Practice db_2 Access Web 3 09-05-2018 05:03 AM
Best Practice - Multiple DB & back ends Shaunk23 General 3 06-07-2012 05:25 AM
Best Practice: multiple values southbymidwest General 16 02-29-2008 05:55 AM
[SOLVED] Multiple Practice Groups for One Person Rusdude Tables 3 05-27-2005 11:42 AM
Form Flds to default based on other flds Rich_Lovina Modules & VBA 6 10-13-2002 06:38 AM




All times are GMT -8. The time now is 05:12 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World