Re: loosing format in data access page

There is no defined order for a table. You should construct your DAP on a
query with a well defined sort order. Such changes of order are frequent
when basing forms and DAP directly on a table instead of a query or a view.

However, as I don't know about the pivot table, it is possible that you can
set the sort order using one of its properties.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"gf570" <gf570@discussions.microsoft.com> wrote in message
news:6CF06301-B185-4EBC-92E8-053371C6379B@microsoft.com...
>I have designed and saved a table in pivot format.
> When I save this table as data access page, the data are transformed. For
> example there is a SUM OF COUNT that is not reflecting the same numbers as
> the table. Anybody knows why this happens? Another example is that all my
> records are not shown on the data access page and their order is changed.