Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 sql query(Urgent!!!)

Author  Topic 

subscriber
Starting Member

8 Posts

Posted - 2006-01-07 : 12:34:40
Records in table are so:

customer_id process total
1 1 10
2 1 20
3 1 25
1 0 5
3 0 20

i wantto subtract total values which process column value 1 from which process column value 0 for each customer_id and list by customer_id.

And i wantto sum(total) value of this query.

how can be this sql query?

sorry my bad english:(

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-01-07 : 12:40:24
Refer this post also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59937
(I could not help subscriber with Access query there)

rockmoose
Go to Top of Page
   

- Advertisement -