colt .45 will shoot out to about 100 metres (effective range about 60m)
ak47 will shoot to about 700 metres. (effective range about 300m)
For both of these you'd have to aim the gun upwards.
The physics of bullet ranges is very complicated, but is mainly affected by:
-muzzle velocity (the speed at which the bullet leaves the gun)
-trajectory of the bullet
-air resistance of the bullet