Search results

Hi, I have a 3 tables Table 1 -Date Flow1 Table 2 -Date Flow2 Table 3 -Date Flow3 Date is the primary key and I would Like to have one table with Date ,flow1, flow2, flow3. How do I do an inner join at once to get this table. Thanks,

Hi, I have a table with five columns Date, Outfall1flow,Outfall2flow, Outfall3flow, outfall4flow now I would like to have just three columns Date, OutfallFlow and OutfallID. I would like to have flow only in one column identified by its id like 1,2,3,4.. How can I do this? Thanks,

Hello, I am trying to analyze 56 years of hourly rainfall data. Right now i have three columns in access database. Date(mm/dd/yyyy), hr(0-23) and hourly Rainfall(inches). I would like to know the count of rainfall events that exceed 2.4 inches in 24 hrs(this means the sum of rainfall in 24...