X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Grouped Query, Access 2007    
post Mar 3 2018, 03:37 PM

Posts: 1
Joined: 3-March 18

I need some help with a grouped report. I have a query that is accessing a table that i cannot alter. It uses three data sets sorted in ascending order to develop a priority of top to bottom. After that initial sort i need to be able to group like items together still using the priority so the top record could be with record 50 or 200 or, etc. Those would be at the top of the report and woudl then group down from there based on the next top record that doesnt match the top one. (and yes there is the possiblity of null values)
Go to the top of the page
post Mar 3 2018, 04:16 PM

Access Wiki and Forums Moderator
Posts: 73,950
Joined: 19-June 07
From: SunnySandyEggo


Welcome to UtterAccess!

Are you able to post a copy of your database with sample data?
Go to the top of the page
John Vinson
post Mar 5 2018, 12:38 AM

UtterAccess VIP
Posts: 4,276
Joined: 6-January 07
From: Parma, Idaho, US

I'm not clear on your requirements or your data structure. What constitutes a "group"? How should the groups be distinguished? My guess is that this can be done using the Sorting and Grouping features of a Report, rather than trying to do it in a Query. But without more information it's hard to say!
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    14th December 2018 - 02:14 PM