I am trying to brainstorm this idea, and I just cannot come up with anything.
I have an MS Access database that will now be tracking invoice information.
The users were wondering if on the form that displays the invoice information, if they can have quarterly and yearly totals for the invoice amount.
On a report this would be pretty easy, with the grouping ability. But I cannot brainstorm how to do this on a form (if it is even possible).
I could have my main form with the invoice information data, then various sub-forms breaking the data down by totals, according to the date. But as a quarter passes, I have to add a new sub-form, and over the course of a few years, it would become a cluttered mess.
Any ideas? Maybe I am making this too confusing.
Thank you for you time!
T.J.
I have an MS Access database that will now be tracking invoice information.
The users were wondering if on the form that displays the invoice information, if they can have quarterly and yearly totals for the invoice amount.
On a report this would be pretty easy, with the grouping ability. But I cannot brainstorm how to do this on a form (if it is even possible).
I could have my main form with the invoice information data, then various sub-forms breaking the data down by totals, according to the date. But as a quarter passes, I have to add a new sub-form, and over the course of a few years, it would become a cluttered mess.
Any ideas? Maybe I am making this too confusing.
Thank you for you time!
T.J.
