Query to pull first 4 records greater than zero

[nmoore5]

Hello, I'm new to Access. Trying to get something done here at work and haven't found something in the forum yet that gives me my answer. I have many records of well (O&G business) that have several months of production. I am trying to pull the first month of production, first 2 months, 3 months, 4 months, and MAX OIL month. Problem is there are two streams of production. So it has to look at Oil and Gas production and pull the first month that is greater than zero of either Oil or Gas then also pull the corresponding Oil or Gas for that same month or months. I'm also trying to pull the Max oil month for each well and the gas production that corresponds to that month. My query currently has UID | WELL NAME | MONTH | OIL | GASI just need a hint on how to tell it to pull first month greater than zero then the next 2, 3, & 4 months. As well as how to pull the Max from the oil column for each well and the gas for that same month. Thanks for any help and please let me know if I've described this well enough.

[June7]

Have you looked at the TOP N qualifier? http://allenbrowne.com/subquery-01.html#TopN

Quite possibly might require several queries (and/or nested subqueries) to get what you want. Or report with subreports.