Sorting & Grouping report
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
I don't know if this is possible but I have a report grouped on a PersonID #
but I would also like it listed alphabetically. I tried grouping on just
the last name but it listed the 5 'Williams' I had all in one group. Is
there any way to combine the grouping or redo my query to both group on ID
and LastName??
--
Gil
.
Relevant Pages
- Re: Getting data from multiple rows into one column
... be you can use this query: ... group by PersonId ... Gert-Jan ... Prev by Date: ...
(comp.databases.ms-sqlserver) - Getting data from multiple rows into one column
... PersonID Degree ... 55 Phd ... I need a create a query that will give me output like this: ... Prev by Date: ...
(comp.databases.ms-sqlserver) - Re: Calculate an Average of row entry fields
... Ok, I somewhat understand your set-up, but the only thing is that I have more ... SELECT personID, AVG ... If that is not enough to convince you to normalize your design... ... create another query field "TotalPerformanceRating" using the following ...
(microsoft.public.access.queries) - Re: Format data to columns
... would cater for any number of rows per personID. ... single report as my demo file shows, but again I can't conceive any reason ... As with my original query this works with one, two or three rows per personID ... Step 1 as proposed by Jerry Whittle ...
(microsoft.public.access.queries) - Re: Counting Combination Services
... I think you are going to have to de-normalize the information with a query and then run a totals query against that to return the results. ... Your other option would be to run a series of queries and populate a work table with the information or use the series of queries in a UNION query. ... SELECT PersonID, "12" as ServiceList ... I can easily add criteria, but I don't know how to set the criteria so that I can display the above desired combinations. ...
(microsoft.public.access.queries) |
|
