Thanks your reply has help me enormously. I probably am approaching this the wrong way but trying to re learn from what was basic level of access from the first place having used excel for most of my databases. I can now show In or Out but still have to key 1 or -1 for out. In excel I probably...