Thank you that worked however the output is a little different than the original which is in access.  Does Access sort differently than sql server?

Chris

Thanks for the advice but the I get the same error.

CREATE VIEW IMEXtrlrUtilUNIONasapSM_VW as SELECT top 100 percent

IMEXtrlrUtilShipMat_VW.OrderNbr, IMEXtrlrUtilShipMat_VW.City,

IMEXtrlrUtilShipMat_VW.Shipper, IMEXtrlrUtilShipMat_VW.Weight from IMEXtrlrUtilShipMat_VW

Union select top 100 percent IMEXtrlrUtilASAP_VW.OrderNbr,...

I still can't get this to work.  I am not getting any errors.  The data is not reporting right.  I could really use any advice.  Could I use a row...

Thanks Bill but I tried max and min with the output not being the same as using Last in Access.  Any other ideas?

Chris