Data Access pages sorting and grouping

[Candice]

Hi,
I am not new to Access, but am new to Data Access pages, and I've recently
inherited a few. I have a dap that is bound to a query that is not sorted;
however, the data appears sorted. I cannot figure out how that is happening -
I cannot find the sorting/grouping button, and there is no sorting/grouping
option on my View menu. I tried resetting the toolbar, but still no
sorting/grouping button. What am I doing wrong? This is Access 2003. thanks!

 

[john]

Hi,
I am not new to Access, but am new to Data Access pages, and I've recently
inherited a few. I have a dap that is bound to a query that is not sorted;
however, the data appears sorted. I cannot figure out how that is
happening -
I cannot find the sorting/grouping button, and there is no
sorting/grouping
option on my View menu. I tried resetting the toolbar, but still no
sorting/grouping button. What am I doing wrong? This is Access 2003.
thanks!

 

[东郭å—]

hao a ren la

 

[Ken Snell MVP]

ACCESS usually uses a default sorting order (often the table's primary key
field) when you don't specify an ORDER BY clause in the query. So add an
ORDER BY clause to the query to get the desired sorting.

 

[Candice]

Thanks for that info Ken...but I'm still bothered as to why I can't find a
way to get to the sorting/grouping dialog...any thoughts? thanks.

 

[Ken Snell MVP]

Because there isn't one.

 

[Candice]

Ok, good, that means I'm not crazy. Thanks for the help.