----- "Richard Broersma" <richard.broersma@gmail.com> wrote:
> The is someone in the MS-Access community that is seeing duplicated
> records (differing by a serial id) disappear with sorting the list by
> the unique serial id. Were there any older version of Postgres that
> did this?
>
> http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1876017&page=0&view=&sb=5&o=&fpart=1&vc=1&PHPSESSID=
>
> --
> Regards,
> Richard Broersma Jr.
>
My reading of the thread is that he is seeing duplicate records that include duplicates of the serial id. The dataset
isderived from a join of tables and Access queries. My guess is that the query he built is not doing what he thinks it
is.This would be especially true if he used the GUI query builder, it tends to build some funky queries (especially
whenrun against non-Jet datasources). When querying Postgres from Access I usually use pass through queries to keep
Accessfrom mucking them up to much.
Adrian Klaver
aklaver@comcast.net