-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Printing Report
- Thread starter macamarr
- Start date
Corticus
Well-known Member
- Joined
- Apr 30, 2002
- Messages
- 1,579
Hi macamarr,
The min condition should do it for you,
Try SQL as follows:
SELECT TOP 1 Min(Tbl1.Field1) AS LastField1, Tbl1.Field1
FROM Tbl1
GROUP BY Tbl1.Field1
ORDER BY Min(Tbl1.key);
replace Tbl1 with your table name and Field1 with your field names. You can then just view the query in design grid, and add the other fields and joins as needed.
or
Make a new query, and drag the table of interest onto the design grid. Click the little summation(sigma?) icon on the button bar, it looks like an odd E. Now change the 'total' dropcombo on the field of interest to 'min'. Now click on the 'view' icon, select SQL, and change Top 5 Min() to Top 1 Min() like shown above.
This is basically the same thing explained in two slightly different ways...
HTH,
The min condition should do it for you,
Try SQL as follows:
SELECT TOP 1 Min(Tbl1.Field1) AS LastField1, Tbl1.Field1
FROM Tbl1
GROUP BY Tbl1.Field1
ORDER BY Min(Tbl1.key);
replace Tbl1 with your table name and Field1 with your field names. You can then just view the query in design grid, and add the other fields and joins as needed.
or
Make a new query, and drag the table of interest onto the design grid. Click the little summation(sigma?) icon on the button bar, it looks like an odd E. Now change the 'total' dropcombo on the field of interest to 'min'. Now click on the 'view' icon, select SQL, and change Top 5 Min() to Top 1 Min() like shown above.
This is basically the same thing explained in two slightly different ways...
HTH,
Upvote
0
Similar threads
