Gary Kjos
garykjos at gmail.com
Mon Mar 5 14:59:40 CST 2012
I guess I would take the same approach you have been with this - separate queries for each need. Perhaps some of them could be joined together for the final result if you wouldn't be mixing granularity so they can logically fit together. Perhaps you would want to create a report with sub-reports for the various queries so you could generate the end results all in one fell swoop. GK On Sun, Mar 4, 2012 at 5:36 AM, Chris Swann <dc8 at btinternet.com> wrote: > Hi all, > > I am hoping that I can get some advice on the best way to extract and > present some data. > > I have a query which is extracting a subset of data from the main table in > the database. > > The query contains the following fields > > Visit Date > Visit Site > HCP > Screen Offered > Screen Declined > Reason for decline > > I need to be able to output the following details, both counts and as > percentages and grouped by Visit Site, Visit Date and with and without the > HCP grouped. > > Number of visits - this will be all records in the query > Number of screens offered - values in field are Asymptomatic, not > applicable, no, yes and NULL values > Number of screens declined - values are clinic test, NCSP test, no and NULL > values > Reason screen declined breakdown - 13 values and NULLs > > I had started creating queries to pull out each of the sets of data needed > but I don't think this will be workable in the long term and am looking for > a more elegant way to extract and present the data. > > Any suggestions and comments would be really helpful. > > Many thanks in advance, > > Chris Swann > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Gary Kjos garykjos at gmail.com