# Record escaping grouping

**URL:** <https://forums.knack.com/t/record-escaping-grouping/12135>\
**Category:** Get Answers\
**Created:** [February 28, 2022, 10:37am UTC](https://forums.knack.com/t/record-escaping-grouping/12135 "2022-02-28T10:37:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Harry](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/harry/32/1459_2.png) [@Harry](https://forums.knack.com/u/Harry)\
**Post date:** [February 28, 2022, 10:37am UTC](https://forums.knack.com/t/record-escaping-grouping/12135/1 "2022-02-28T10:37:35Z")

</div>

I have a table displaying appointments and they’re grouped by date and also whether the appointment has been confirmed. However, one of the records is escaping the grouping and I’m not sure why:

 ![Screenshot 2022-02-28 at 10.33.05](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/7/710bd2f49fb47b15c9f1dfc9fab7e4a253b6adc1.png)

I’ve added the first column to show the record that has escaped the grouping does indeed have the field Confirmed as Yes.

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [February 28, 2022, 7:36pm UTC](https://forums.knack.com/t/record-escaping-grouping/12135/2 "2022-02-28T19:36:07Z")

</div>

Hey @Harry, bit of an odd one. Be useful to see what’s going on in the table and the page.  
As you just down the road from me we can jump on another short Zoom and take a look.

---

<div class="post-metadata">

**Author:** ![Harry](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/harry/32/1459_2.png) [@Harry](https://forums.knack.com/u/Harry)\
**Post date:** [March 2, 2022, 1:24pm UTC](https://forums.knack.com/t/record-escaping-grouping/12135/3 "2022-03-02T13:24:21Z")

</div>

@CarlHolmes That would be great thank you! I’ll drop you an email 🙂

---

<div class="post-metadata">

**Author:** ![Harry](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/harry/32/1459_2.png) [@Harry](https://forums.knack.com/u/Harry)\
**Post date:** [March 4, 2022, 3:44pm UTC](https://forums.knack.com/t/record-escaping-grouping/12135/4 "2022-03-04T15:44:11Z")

</div>

It appears to be forcibly sorting them by date/time. It doesn’t matter what groupings I do and what sorting I do, it is always sorting them by date/time.