If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to add like records together for an exclusive total
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? |
#2
|
|||
|
|||
how to add like records together for an exclusive total
Create a Totals query.
Group By on lognum and Sum on sltotal "Leslie Porter OHV" wrote in message news 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? |
#3
|
|||
|
|||
how to add like records together for an exclusive total
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" wrote in message news 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? |
#4
|
|||
|
|||
how to add like records together for an exclusive total
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" wrote in message news 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? |
Thread Tools | |
Display Modes | |
|
|