Sounds like you tried kief, kief is a powder that you might say resembles sand.

Hash is brown and usually pressed into a block or rolled into a ball.

kief: http://upload.wikimedia.org/wikipedi...Joes_joint.jpg

hash: http://www.onlinepot.org/hash/_deriv...order_Hash.gif