Hey guys,
I have a form that is set up like a spreadsheet. I didn't create this form, it has been handed off to me and I'm not exactly an Access expert by any means.
What I need to do is add a new row to the form for "totals" and pull numerical entries from a few different tables and get the sum off all cells in each of the columns.
For example,
I have column A which pulls from table A and I need to calculate the sum of column A and display it in a label or whatever on the form. Then beside it I need another label on the form displaying the sum of column B in table B. And so on and so forth.
This doesn't seem like it would be too difficult of a task for someone who knows Access, however I know very little about Access when it comes to forms. I was hoping someone could help.
I have a form that is set up like a spreadsheet. I didn't create this form, it has been handed off to me and I'm not exactly an Access expert by any means.
What I need to do is add a new row to the form for "totals" and pull numerical entries from a few different tables and get the sum off all cells in each of the columns.
For example,
I have column A which pulls from table A and I need to calculate the sum of column A and display it in a label or whatever on the form. Then beside it I need another label on the form displaying the sum of column B in table B. And so on and so forth.
This doesn't seem like it would be too difficult of a task for someone who knows Access, however I know very little about Access when it comes to forms. I was hoping someone could help.