sql call returns different number of records

K

kabaka

Hi

When I use the following in SQL design view it returns 265 records as it
should.

SELECT Adjustments.* FROM Adjustments WHERE (((Adjustments.Disactive_Date)
Is Null) AND ((Adjustments.Adjustment_Number)<>0));

However, when I attempt to call a recordset using the following code it
returns 414 records. Why?

(code...)
sql = "SELECT Adjustments.* FROM Adjustments WHERE
(((Adjustments.Disactive_Date) Is Null) AND
((Adjustments.Adjustment_Number)<>0));"

Set rst = dbs.OpenRecordset(sql)
if rst.RecordCount
rst.MoveLast
rst.MoveFirst
Me.countbox.Value = rst.RecordCount
Else
Me.countbox.Value = 0
End If
(code...)

Thanks
 
Top