Complex SQL query Please help

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 423,560 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,694 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 575 | Replies: 0

•

Join Date: May 2008

Posts: 1

Reputation: Techsavy is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Techsavy

Offline

Newbie Poster

Complex SQL query Please help

May 4th, 2008

Hello,

I am trying to analyze 56 years of hourly rainfall data.

Right now i have three columns. 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. Meaning if the sum of Rainfall exceeds 2.4 inches in 24 hours then that is one event.

once an event is identified the next event should be identified with a gap of 72 hours.

Any suggestions on how to query this?

Thanks,