<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?

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

"Leslie Porter OHV" <(E-Mail Removed)> wrote in
message news1484FAE-7C61-4A04-9E8B-(E-Mail Removed)...
> <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?
>

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?


"Klatuu" wrote:

> Create a Totals query.
> Group By on lognum and Sum on sltotal
>
> "Leslie Porter OHV" <(E-Mail Removed)> wrote in
> message news1484FAE-7C61-4A04-9E8B-(E-Mail Removed)...
> > <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?
> >
>
>
>

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

in access2003 with query open goto view and click totals.

tadda!!

thanks for pointing me in the right direction!!

"Klatuu" wrote:

> Create a Totals query.
> Group By on lognum and Sum on sltotal
>
> "Leslie Porter OHV" <(E-Mail Removed)> wrote in
> message news1484FAE-7C61-4A04-9E8B-(E-Mail Removed)...
> > <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?
> >
>
>
>