Measure the depth of your hole by measuring how much pipe you still have above the ground. Then, drill into the sand. You will need at least three feet of pipe down into the sand so that you can have a constant water flow. The deepest you can practically go with this sort of well is about 20 feet and above,