it's been a while since i have done anything with databases, and i am play around with this as a relpacement to a spreadsheet my boss keeps messing up.
basically i create a daily financial report called a greensheet every day. this report has daily, month to date, and previous year: month to date categories...
however two very important fields are [Previous Outstanding] and [Total Outstanding To Date], this is the most important field on the report, and is the one that if i have a day off, my boss attempts to do and i have to fix.... pretty much every time.
here is the logic behind the Previous Outstanding
If today is the 1st day of the month, this will be the same yesterday's Total Outstanding to Date.
If today is not the 1st day of the month, this will be the same as yesterdays Previous Outstanding (this number only changes once a month, but it is on every greensheet)
If Today is the very 1st record, the todays value is 0
is there any way for me to define the field so that that logic is automatic?
once i get this figured out, i will probably be bugging you guys again. btw, i am using access 2010 on microsoft xp. thanks folks!