# MS Access help

**URL:** <https://boards.straightdope.com/t/ms-access-help/179904>\
**Category:** Factual Questions\
**Created:** [June 5, 2003, 7:20pm UTC](https://boards.straightdope.com/t/ms-access-help/179904 "2003-06-05T19:20:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Beastal](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Beastal](https://boards.straightdope.com/u/Beastal)\
**Post date:** [June 5, 2003, 7:20pm UTC](https://boards.straightdope.com/t/ms-access-help/179904/1 "2003-06-05T19:20:23Z")

</div>

Hi all,

I have MS Access XP.

I have developed a report, and I need each record in this report to be sorted by Date (one of the fields in the report). How do I do this?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![drachillix](https://avatars.discourse-cdn.com/v4/letter/d/48db29/32.png) [@drachillix](https://boards.straightdope.com/u/drachillix)\
**Post date:** [June 5, 2003, 8:08pm UTC](https://boards.straightdope.com/t/ms-access-help/179904/2 "2003-06-05T20:08:04Z")

</div>

have you tried the “sorting and grouping” button on the toolbar. You can twist your report all kinds of different ways with it.

Personally I find it easier to make the underlying query do all the sorting then just have the report format it.

---

<div class="post-metadata">

**Author:** ![Beastal](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Beastal](https://boards.straightdope.com/u/Beastal)\
**Post date:** [June 5, 2003, 8:47pm UTC](https://boards.straightdope.com/t/ms-access-help/179904/3 "2003-06-05T20:47:18Z")

</div>

Ahh yes, that worked. Thanks!

While we’re at it… anyone have any idea how to remove the navigation controls at the bottom of a form?

---

<div class="post-metadata">

**Author:** ![zoid](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/zoid/32/336_2.png) [@zoid](https://boards.straightdope.com/u/zoid)\
**Post date:** [June 5, 2003, 8:51pm UTC](https://boards.straightdope.com/t/ms-access-help/179904/4 "2003-06-05T20:51:58Z")

</div>

The properties of the form itself (not the detail section) include;

Record Selectors (Yes/No) and  
Navigation Buttons (Yes/No)

Play with these and the other settings on the Format tab to get the look & feel you want