Data Access pages sorting and grouping

C

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!
 
J

john

Candice said:
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!
Click to expand...
 
K

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.
 
C

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.
 
Top