Search results

Neil, the purpose of keeping a column for balance total is to know what the total on the account was at the time of that entry. Right now if I need to know what the balance of my account was at, say January 3, that information is lost. Gary, I'm not sure I understand what you are asking for.

Thanks, DateDiff looks very promising. It will be for showing entries in the last month, last week, etc. Also thanks Neileg. I agree, I've been thinking it over, and I'll do it by query. I already calculate the balance every time I do an entry, so I'll just store that value in the balance column.

I want to have a program where the balance of an account is always updated and stored in a column. In oracle I would use pl/sql, does Access have a similar capability? Also I want to be able to add and subtract date types, for example, to get entries from the last month. Oracle date type can do...