Join Date: Dec 2001
Location: Belleville, Illinois
Thanked 22 Times in 17 Posts
Re: OT, Access or Excell Gurus Help:
At least with my old version ('97) all you need to do to name a horizontal line is put the name you want in the first column. But I don't think that the software will recognize it as a heading and repeat it when it prints a second page to the right.
As for formulas, try something like " = C17 + D17 * .3 + .05" It works just like Algebra 101; takes the number in cell D17 and multiplies it by .3, then adds the number in cell C17 and adds .05, and puts the result in the cell where you put the formula.
There are lots of gotcha's waiting. Some common ones are calling for an arithmetic operation on a cell that has text in it, unbalanced parantheses, and dividing by a cell that has zero in it.
Call me this morning if you want some more help. The Boss is going to have me doing yard work this afternoon.