Query/VBA to Sum the records

[pedie]

Hi, i need help with Query/VBA to Sum the records in table1 in my database

I want to sum all if field_CC = "1002".

Thanks in advance.
Pedie

 

[james_lankford]

sum or count ?

select 
  count(*) as this_is_the_number_of_rows
from 
  my_table
where
(
  field_CC ='1002'
)

select 
  sum(field_1) as this_is_field_1_from_every_row_added_together
from 
  my_table
where
(
  field_CC ='1002'
)

 

[pedie]

Thanks for Quick Response...is this SQL?

 

[pedie]

I tried this way....changing the field names and it errors

From SQL View

[/FONT]
[FONT=Courier New]SELECT Sum(Exps) AS Expr1
FROM Table1
WHERE (((Table1.[CC_N])="1009"));

Also tried this

[/FONT]
[FONT=Courier New]Dim LTotal As Currency
'LTotal = DSum("Exps", "Table1", "CC_N = 1009")
LTotal = DSum("Exps", "Table1", "CC_N = 1009", "Q1234 = QQ102")

I want to check 2 conditions if posible in dsum/sum whichever ways is possible..

sum or count ?

select 
  count(*) as this_is_the_number_of_rows
from 
  my_table
where
(
  field_CC ='1002'
)

select 
  sum(field_1) as this_is_field_1_from_every_row_added_together
from 
  my_table
where
(
  field_CC ='1002'
)

 

[xenou]

SELECT Sum(Exps) AS Expr1
FROM Table1
WHERE (((Table1.[CC_N])='1009'));

The above *should* work - assumptions are that there are fields EXPS and CC_N in a table called TABLE1.

But you must be sure that CC_N is a TEXT field if you are putting the value in quotes. If CC_N is a NUMBER field then don't use the quotes around 1009. Also, be sure that EXPS has no NULL values in it as NULL cannot be summed and this ruins the total.


----------------------------------------------------------------------------

LTotal = DSum("Exps", "Table1", "CC_N = 1009", "Q1234 = QQ102")

The above looks odd. Is Q1234 a field?

 

[pedie]

Xen, thank you very much!!! this is what I am looking for....

Thanks and Regards
Pedie