yup, that did the trick. The primary key was not set correctly.

Thanks to all for your help.

Have a great weekend.

I think I might know what is happening. in this linked table, the primary key for the records are not disctinct in the records for each customer. However, when...

Hi Matt,

thanks again for the help. I used the order by in access and the records are still different.

in access, the output is (e.g.):

name (field) balance (field)...

Hello,

The order is the same in both SQL and MS access. The problem is that the data that I get out of the access query is incorrect. Specifically,...

Hi Matt,

This is what I am using. You will have to excuse any lack of info as I am newer to using both access and sql:

in SQL query analyzer...

Hi,

Member is a table that I have linked from the SQL odbc database.

there are negative number in the rows (this I do not have an issue with).

I...

thought I should add this info:

When I query Acces with Sum Of balance: Sum(Abs([member].balance))

The balance is equal to what it should be, that is, what it is in the SQL...