Thread: new column and filter

Hi, im working on a Access database, pretty basic, im not too good at access but understand the basics.

What I have is a table, and am pulling the table and organizing the data. The first 2 that the input asks are these 2 names

MÁQUINAS E EQUIPAM
INSTALAÇÕES

The second 2 names are

Pindamonhangaba Cilindros
Pindamonhangaba SBQ

Then what I want to do in query design the Centro, i want to organize it where the multiple names dont come out and instead only shows the name once and sums all the #s to that name. So when I run the query, in the Centro row, the name

AÇOBRUTO

will show up 20+ times, i just want to sum the numbers next to it and have it show up once for each name. I have about 1 million lines like this, I just created a small one.

*also wanted to know if i wanted to add a new column how i would do that which divides this # by 12.

Anyone can help, thank you,

In the QBE, create an expression in a new field (column) type the new name of the field followed by a colon. Example would be MyNewField:

Follow this by typing a formula =[OldFieldName]/12

Make sure to click on the display check box. This should give you a new field with a new name and result.

Post back if you need additional help.

Alan