Search results

Hi, My database has 3 fields ID,Cust_Balance,Cust_Type. I need to assign Cust_Type as 1,2,or 3 based on Cust_Balance amount. If Cust_balance is lessthan 3 million then Cust_Type is 1,if between 3 and 10 million then type 2 and,more than 10 million as type 3.How do i accomplish this in...

Hi, here is a query which returns rolling sum for past5days.The resulting table has threee columns,namely, MyDateFiled ,MyValue,Past5DaySum SELECT tblData.MyDateField, tblData.MyValue, (SELECT SUM(a.MyValue) FROM tblData As a WHERE DateDiff("d",a.MyDateField,tblData.MyDateField) Between 0...

Thanks guys , I figured the solution using VB6 ,hope this would be useful to others as well. Here goes the code in VB6: ------------------------- Dim adoConn As New ADODB.Connection Dim adoRecSet As New ADODB.Recordset Dim adoRecSetSub As New ADODB.Recordset adoConn.ConnectionString = "...

hi , The Mailman ,ur response gives me a 'cumulative sum',I am in the requirement of 'Rolling Sum'.Something like this: RAINFALL , ROLLING_RAINFALL A , A+B+C+D+E B , B+C+D+E+F C ...

Hi, this is my first question in this site. I have a database with the following fileds and associated values areacode dt rainfall --------------------------- AAA 1/1/2005 10 AAA 2/1/2005 4 AAA 6 . 0 . ...