Search results

hello Jal, Thank you for the response. All the three tables have same set of dates. In the resulting table I would like to have DAte, flow1,flow2,flow3. Hope this clears the doubt

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,

Will the following code be an alternative to the VBA code that you mentioned? select t1.d1 from (Select date as d1, from table name group by date-field having sum(rainfall) >2.4) as t1, from (Select date as d2, from table name group by date-field having sum(rainfall) >2.4) as t2 where t1.d1...

Hello, Thanks a lot! I understood the first part where it gives me all the days that exceed a rainfall of 2.4 inches. So the second part is a VBA code that has to be run through access VBA editor? Please let me know, 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...