What's the query in ms access and sql server to get the last 10 records for TransactionNumber by group of ItemNumber.
SELECT [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], SH3.Price_Source, [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], SH3.Mum_Code, [login to view URL], [login to view URL], SH3.DAT2_LAST_UPDATE, [login to view URL], [login to view URL]
FROM SH3
WHERE ((([login to view URL])=18330408 Or ([login to view URL])=18330409 Or ([login to view URL])=18330410 Or ([login to view URL])=21401400 Or ([login to view URL])=24041590 Or ([login to view URL])=24041600 Or ([login to view URL])=24061640 Or ([login to view URL])=24061650 Or ([login to view URL])=24061660 Or ([login to view URL])=24061670 Or ([login to view URL])=28140015 Or ([login to view URL])=28140030 Or ([login to view URL])=30205240 Or ([login to view URL])=30205465 Or ([login to view URL])=30208700 Or ([login to view URL])=30225110 Or ([login to view URL])=4650412 Or ([login to view URL])=4650414 Or ([login to view URL])=4650416));
## Deliverables
1) Query as requested above
## Platform
MS Access 2003, SQL Server 2005