Querying the "minimum value" record

[LunaticFringe82]

I'm developing a query using baseball statistics where I'm trying to isolate the first batter in each inning...



So I want to see all records for team, date, inning where the outs=0 and there are no runners on base (ROBSit=0). However, there is one other loophole that I need to close:

Let's say the first batter of the inning hits a home run. For the inning in question, there will be TWO records where outs=0 and ROBSit=0 and I need to isolate the one that occurred FIRST.

My records have a sequence number (Yr#). So let's say the first batter (Yr# 1000) homered. Then the next batter (Yr# 1001) struck out. I do not want the strike out to be part of my dataset.

How do I query Yr# to display only the MINIMUM value given team, date, inning, outs=0, and ROBSIt=0?

Thanks for any help!!

Gary

[blue4512]

Run a query that calculates totals* and for the total column select "min"
*on the design tab select the totals option and an additional line will be added to your query where you can select Min for the yr# field