how to add like records together for an exclusive total

[Leslie Porter OHV]

<sigh> here i am agian being dumb and not understanding...

i have a query

lognum slice1 slice2 slice3
sltotal[slice1]+[slice2]+[slice3])
72000 300 200 250 750
72000 150 100 0 250
72001 100 200 200 500
72001 200 200 0 400

i want it to look like this....

lognum sltotal:?
72000 1000
72001 900

i remeber some kind of exclusive command but i dont think it will give me
what i want. can some one help an unlearned man?

 

[Klatuu]

Create a Totals query.
Group By on lognum and Sum on sltotal

 

[Leslie Porter OHV]

i thought it might be that easy... except i dont have a totals query...
only:
select
cross-tab
make table
update
append
delete

to choose from. is this something i have to add or get?

Create a Totals query.
Group By on lognum and Sum on sltotal

<sigh> here i am agian being dumb and not understanding...

i have a query

lognum slice1 slice2 slice3
sltotal[slice1]+[slice2]+[slice3])
72000 300 200 250 750
72000 150 100 0 250
72001 100 200 200 500
72001 200 200 0 400

i want it to look like this....

lognum sltotal:?
72000 1000
72001 900

i remeber some kind of exclusive command but i dont think it will give me
what i want. can some one help an unlearned man?

 

[Leslie Porter OHV]

AAHHHH... im an idiot!!...

in access2003 with query open goto view and click totals.

tadda!!

thanks for pointing me in the right direction!!

Create a Totals query.
Group By on lognum and Sum on sltotal

<sigh> here i am agian being dumb and not understanding...

i have a query

lognum slice1 slice2 slice3
sltotal[slice1]+[slice2]+[slice3])
72000 300 200 250 750
72000 150 100 0 250
72001 100 200 200 500
72001 200 200 0 400

i want it to look like this....

lognum sltotal:?
72000 1000
72001 900

i remeber some kind of exclusive command but i dont think it will give me
what i want. can some one help an unlearned man?