Hi all, can anyone tell me why I am getting 5 results back from my rsDiv query and only one result back from my rsProdLine query? Has anyone encountered this type of behaviour before? Am I using the wrong syntax? I'm pretty new to ADO soo..... btw - it is an access db not a foxpro db...


Dim db As Database
Dim rsDiv As Recordset
Dim rsProdLine As Recordset

Set db = CurrentDb
Set rsDiv = db.OpenRecordset("select distinct division as div " + _
"from productline]")
Set rsProdLine = db.OpenRecordset("select productline " + _
"from productline")

MsgBox rsDiv.RecordCount
MsgBox rsProdLine.RecordCount