Question about a table

  • Thread starter Thread starter Sandi
  • Start date Start date
S

Sandi

Hi,
I am designing a table with currency amounts and I have to give a grand
total at the bottom. How can I do this? I am new to Access so please give
me a simple answer.

Thanks,
Sandi
 
Sandi said:
Hi,
I am designing a table with currency amounts and I have to give a grand
total at the bottom. How can I do this? I am new to Access so please give
me a simple answer.
Click to expand...

Database tables are not spreadsheets. All of the rows are the same and
represent data, not calculations. You need to do your totaling in a query,
form, or report.
 
Hi,
I am designing a table with currency amounts and I have to give a grand
total at the bottom. How can I do this? I am new to Access so please give
me a simple answer.

Thanks,
Sandi
Click to expand...

Don't.

Access tables are repositories for actual data. They should not
contain calculations or totals.

You can create a totals Query. Create a Query based on your table;
select this currency field or fields. Click the Greek Sigma icon and
set the Totals row to Sum for these fields.

Or, create a Form or a Report based on your table; in the Form or
Report Footer, put textboxes with Control Source

=Sum([fieldname])

to sum that field. This lets you display both the detail data and the
sum on the same screen or sheet of paper.
 
Thank you for your reply but it doesn't seem to work for me.

I created a form and in the footer I put the textboxes with the control
source. When I view the form all it gives me is the amount for each record
and not the grand total for all the records.

What am I doing wrong?

Thanks.



John Vinson said:
Hi,
I am designing a table with currency amounts and I have to give a grand
total at the bottom. How can I do this? I am new to Access so please give
me a simple answer.

Thanks,
Sandi
Click to expand...

Don't.

Access tables are repositories for actual data. They should not
contain calculations or totals.

You can create a totals Query. Create a Query based on your table;
select this currency field or fields. Click the Greek Sigma icon and
set the Totals row to Sum for these fields.

Or, create a Form or a Report based on your table; in the Form or
Report Footer, put textboxes with Control Source

=Sum([fieldname])

to sum that field. This lets you display both the detail data and the
sum on the same screen or sheet of paper.
Click to expand...
 
Sandi said:
Thank you for your reply but it doesn't seem to work for me.

I created a form and in the footer
Click to expand...

Form Footer or Page Footer? Needs to be the former.

I put the textboxes with the control
source. When I view the form all it gives me is the amount for each record
and not the grand total for all the records.
Click to expand...

What ControlSource exactly?
 
Back
Top