Hi; I am building a database to track my investment accounts. I am not too knowledgeable on Access, I want to learn / do it myself, but don't want to spend the time to figure it all out myself. I'd like someone I can ask questions of as I go along. Right now, and this may be my only question, I can't envision how, in a query, to differentiate between "closed" positions (stock bought, then sold = position closed) and still open positions (stock bought & still holding, but I expect you guys get this). Do I need a "position closed" field checkbox? else would you write me the query I would use? Thanks!