I also need one basic lense for vacation pics, and then a good all around Aquarium lense.
Quantaray has a 70-300mm lense with macro function for $200. Is this decent of junk?
I just cant seem to get as close and crisp of pic with the D40, and I dont want to spend 600-1200 bucks for a single lense.
You can get the best camera they make, you will never get what you want without good lenses, period!
The cost for the upgrade or the cost of a better lens, I'd coff up the money for a better lens, get you a prime lens with an f1.8, little work it will do the macro shots for your fish tank & they are relatively cheap for prime lens, (no zoom). I'm telling you now ask they guys what they would prefer, a few more mega pixels or a better lens.
Again, go to KEH.com, find your camera & get a decent lens for your macro, no this lens will not be the all around lens, that is another subject. To really get the most out of the lens you have, you will need to deal with a tripod to get the most of it & then knowing how to make adjustments, these package lenses aren't the best IMO.
Shoot BigT a pm, Llarian, or even Blaze88, get their recommendations of a good macro lens for your camera, then call them guys at KEH & they will help get you a lens for that, If you don't like what you get they have a no hassle refund, completely, I think even shipping. You should be able to get that at a very affordable price.