Programming Forums - View Single Post

InfoGeek · Nov 2nd, 2005, 11:20 AM

I think it'll return NULL. Also use 'as' in your query like

rs.Open "SELECT SUM(salary) as total FROM employees WHERE salary > 55000",db1

then you can use it in further expressions.

Also, Animated avatars are not allowed on this forum. So change your avatar.

Edit: MyPosts%100==0!

Nov 2nd, 2005, 11:20 AM	#2
InfoGeek Professional Programmer Join Date: Jun 2005 Location: India, The great. Posts: 435 Rep Power: 4	I think it'll return NULL. Also use 'as' in your query like (Toggle Plain Text) rs.Open "SELECT SUM(salary) as total FROM employees WHERE salary > 55000",db1 rs.Open "SELECT SUM(salary) as total FROM employees WHERE salary > 55000",db1 then you can use it in further expressions. Also, Animated avatars are not allowed on this forum. So change your avatar. Edit: MyPosts%100==0! __________________ PFO - My daily dose of technology.