Access vs VB ado

From: Len (anonymous_at_discussions.microsoft.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 11:11:12 -0800

Hi:
I'm not sure what forum this should be in. I have a query is Access2003 and cut and paste the query to VB6 (SP5) using ADO. I get a record count of 2,391 in Access but 2,238 in VB. Its easy to see missing records. Any help would be appreciated. Here's the query:

SELECT ARSUBS02.*, ProductNew2.*
FROM ARSUBS02 INNER JOIN ProductNew2 ON ARSUBS02.ITEM = ProductNew2.Code
WHERE (((ProductNew2.Pub)="GI"))
ORDER BY ARSUBS02.CUSTNO, ARSUBS02.ITEM,ARSUBS02.NR_DATE;