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...

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 . ...