Forum Discussion
grouping & sorting on access report
UPDATE: i finally figured it out and got the report results i needed!! Thanks to all who replied! I've spent HOURS searching for answers / examples on how to control how my data is displayed...
Have you gotten your issue resolved?
- FINALLY GOT WHAT I NEEDED!! YEAHHHH!!!
hi jim, sorry for the delayed response, got tied up at work w/ long hours. I have my report sorted how i need it and my patients are unofficially grouped together, which is as close to perfect as i could get it. Another community member had sent me some code for my query to compare dates for each patient and return the oldest date, and this oldest date is how the report Sorts my patients.
When i try to create a level of Grouping (via the Group & sort pane at the bottom of the design view), neither version of access that i'm working with (2007 & 2016) will allow me to perform a group after a sort order has been set. Access just crashes and i have to reopen and remove the attempted grouping...
