well...generally, if you want just a fish, turn off the tank lights and put the lens between an inch and right on the glass and use a flash
if you want the whole tank, darken the room, turn on the tank lights, and no flash
thats general....you'll have to fiddle with your camera settings to figure out what works...there may be a sticky on this in the FW Rate My Tank, but I am not sure