Autimatic transmission not accelerating when in drive, but does when in park

My Nissan altima 2007 doesn’t accelerate when in drive but does accelerate when in park,will changing the full gear box solve this problem.I had service the gear, change the oil but still same problem