I have an Access 2010 Database that links to a SQL Server View. If I look at the view in SQL Server with specific criteria I get 54 Records. If I run the exact same query in Access for the attached view I also get 54 records however some of the records are duplicated where they are not in SQL Server. I've narrowed it down that we have a product line field and a sub-measure field. If the sub-measure field is the same but the product line field is different I get 2 records for the same product line and the other product line is missing. Anybody have an idea why this would happen?