PC Review


Reply
Thread Tools Rate Thread

how to add like records together for an exclusive total

 
 
Leslie Porter OHV
Guest
Posts: n/a
 
      31st Oct 2008
<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?

 
Reply With Quote
 
 
 
 
Klatuu
Guest
Posts: n/a
 
      31st Oct 2008
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?
>



 
Reply With Quote
 
Leslie Porter OHV
Guest
Posts: n/a
 
      31st Oct 2008
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?
> >

>
>
>

 
Reply With Quote
 
Leslie Porter OHV
Guest
Posts: n/a
 
      31st Oct 2008
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?
> >

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Total certain records Robbro Microsoft Access Getting Started 1 22nd Dec 2009 08:11 PM
Total records Paulo Roberto Microsoft ASP .NET 1 13th Aug 2007 02:48 AM
Total Records =?Utf-8?B?Sm9obiBD?= Microsoft Access 1 28th Apr 2005 07:36 PM
Total records Ha Microsoft Access Reports 1 7th Feb 2004 01:44 AM
querying exclusive records Dave Cullen Microsoft Access Queries 3 8th Dec 2003 10:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:54 PM.