Ok, I have the following SQL Query in both Access and VB... In access, it pulls two records, just as it should, but in VB when I do a recordset.recordcount, it gives me "-1" and only opens one recordset into my datareport.
VB Code:
SELECT Company.Name, Company.Address, Company.City, Company.State, Company.Zip, Company.Telephone, [Units.Number], Units.Price, Units.CustomerNumber, Customers.Name, Customers.Address, Customers.City, Customers.State, Customers.Zip, Customers.Telephone, Customers.Balance, Customers.LastPayment FROM (Company INNER JOIN Units ON Company.Number = Units.Company) INNER JOIN Customers ON (Units.CustomerNumber = Customers.Number) AND (Company.Number = Customers.Company)
Like I said, It will work in Access, but vb doesn't want to do it...
oh, btw... I'm invoking it by DB.Execute
Thanx,
squirrelly1
