J
jon
I didn't design the database, which was put all on one table, should've used
excel if they were gonna do it that way!
excel if they were gonna do it that way!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
jon
A column. A column! Data can be entered in rows (records) or columns. Access'
sum function will provide the sum of each like item, but not just a total
going straight down.
There's no need to be condescending. My comment meant that a whole database
worth of information was placed into a single table, rather than having a
different table for different objects, it was all crammed onto one. I have no
trouble writing queries, but pulling the data I need is easy, doing something
simple with it eludes me. The querie will give me a datasheet with prices
listed in a column. I would like to get a sum of the values in the column.
sum function will provide the sum of each like item, but not just a total
going straight down.
There's no need to be condescending. My comment meant that a whole database
worth of information was placed into a single table, rather than having a
different table for different objects, it was all crammed onto one. I have no
trouble writing queries, but pulling the data I need is easy, doing something
simple with it eludes me. The querie will give me a datasheet with prices
listed in a column. I would like to get a sum of the values in the column.
J
John Vinson
I didn't design the database, which was put all on one table, should've used
excel if they were gonna do it that way!
I have to agree with Joseph that your question (if it is a question)
is thoroughly obscure; your snarling at his attempt to be helpful was
really out of line.
If you want to see a total at the bottom of a table datasheet... You
can't. Tables are not spreadsheets and are not designed to work as
spreadsheets.
You can *display* the data together with a sum of any or all columns
by creating a Report based on the table, and putting textboxes in the
Report Footer with control source of
=Sum([column name])
John W. Vinson[MVP]
J
jon
The question was simple. How to display a sum at the bottom of a column.
Thank you for answering it.
The additional information is required in order to post the question. Have
you not noticed how people often use excel when access would work? My case is
unique. Someone used access as if it were excel, placing customers, orders,
tests, products, locations, and prices all in one table.
Thank you for answering it.
The additional information is required in order to post the question. Have
you not noticed how people often use excel when access would work? My case is
unique. Someone used access as if it were excel, placing customers, orders,
tests, products, locations, and prices all in one table.
John Vinson said:I didn't design the database, which was put all on one table, should've used
excel if they were gonna do it that way!
I have to agree with Joseph that your question (if it is a question)
is thoroughly obscure; your snarling at his attempt to be helpful was
really out of line.
If you want to see a total at the bottom of a table datasheet... You
can't. Tables are not spreadsheets and are not designed to work as
spreadsheets.
You can *display* the data together with a sum of any or all columns
by creating a Report based on the table, and putting textboxes in the
Report Footer with control source of
=Sum([column name])
John W. Vinson[MVP]
J
jon
How does one display the sum at the bottom of a column?
That is the question. Everything else was typed because you cannot post just
a question, something has to be typed in the message box.
That is the question. Everything else was typed because you cannot post just
a question, something has to be typed in the message box.
J
John Vinson
The additional information is required in order to post the question. Have
you not noticed how people often use excel when access would work? My case is
unique. Someone used access as if it were excel, placing customers, orders,
tests, products, locations, and prices all in one table.
I've seen both directions of the error; "committing spreadsheet upon a
database" is a very common mistake. My phrase for the situation is
"You can use a crescent wrench to drive nails, but that doesn't make
it a hammer"!
John W. Vinson[MVP]