I configure a sql statement in access to get the data that I need and everything is exactly like i want it. However, when I copy that sql string to visual basic and use the cnn.execute sql command I dont get that same data back as I did when I ran it in access? I do not understand why ( I did another command and copied that one and it returns the same data as it does in access but all others I try doesnt) Any help or suggestions would be great. Below are what each return

in access
id name open closed
1 tom 2 1
2 bill 1 0


in visaul basic
id name open closed
1 tom 3 1

Sorry for reposting but hit wrong key and post too early.