Sorting & Grouping report
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: Display fields Limited on Values
... you could normalize with a union query. ... SELECT PersonID, Require1 as Met, "Require1" as Requirement ... "Duane Hookom" wrote: ... (microsoft.public.access.queries) - Re: GROUP BY and performance
... If you use the sample I provided and execute the query the result set will ... contain the person information for "Jim Bo" twice since he is a member of ... Essentially I want to GROUP BY personid. ... >> familyid int, ... (microsoft.public.sqlserver.programming) |
|