Question about a table

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
 
R

Rick Brandt

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.

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.
 
J

John Vinson

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

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.
 
S

Sandi

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

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.
 
R

Rick Brandt

Sandi said:
Thank you for your reply but it doesn't seem to work for me.

I created a form and in the footer

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.

What ControlSource exactly?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top