So, joy of joys, I get to build an access database for my work. We have to track contract information on things that go over $1 million.
I've figured out a number of things, but there's one thing I'm stalling on, but I'm not sure if it's even doable.
I'd like to create a running total in the table.
Since the invoices and contracts have change orders (COs) which can alter the amount of the document, what I'm doing is keeping the COs in the same table. I do know how to do a calculated field, but the issue is that it doesn't populate if a field is empty. So, I can tell it to add the base amount to whatever the increase/decrease amount is of the CO1, but it won't fill if CO1 is blank. And goes to negative numbers if I put it at 0.
I looked online, but all I'm getting is info about queries.
Is there a way to do this? Or is it something where I design a query and then pull in the results on to the form? Or... I need options. I've only done two classes on this thing, lol.
I've figured out a number of things, but there's one thing I'm stalling on, but I'm not sure if it's even doable.
I'd like to create a running total in the table.
Since the invoices and contracts have change orders (COs) which can alter the amount of the document, what I'm doing is keeping the COs in the same table. I do know how to do a calculated field, but the issue is that it doesn't populate if a field is empty. So, I can tell it to add the base amount to whatever the increase/decrease amount is of the CO1, but it won't fill if CO1 is blank. And goes to negative numbers if I put it at 0.
I looked online, but all I'm getting is info about queries.
Is there a way to do this? Or is it something where I design a query and then pull in the results on to the form? Or... I need options. I've only done two classes on this thing, lol.
Comment