Well, its been a couple of years since I have used either program, and both are giving me problems. The main one is with Access (which is a pretty much useless prog if you ask me, Excel can do just about everything it can). Anyway the problem is I am trying to add up 4 fields and put that total in the next column. I should be able to put in a simple sum function, but it doesnt work no matter how I try to format it. I have tried the numbers straight up, the field names in brackets, quotes, and parentheses. I have tried this with the 97 and 2002 versions, but I need to be able to do this in the 97 version for the sake of my teacher being more familiar with it (though if you aint noticed, she doesnt know anything or I wouldnt be asking) I have looked at online and offline examples of how it should be formatted and it still doesnt work. It always says the value isnt valid, but the field is set to number like its supposed to be. Anyway I would really appreciate it if someone could tell me how they added up fields in Access cause its driving me nuts. The problem I have with Excel is I need to merge two cells vertically. Horizontal merges arent a problem, but it doesnt work trying it vertically since it deletes the text in the bottom cell and even tells me that will happen before they are merged, so how do I fix that?