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)