I'm converting an Access to SQL. This is one statement, and I could use some help. I have tried, but I still can't get it right.

Anyone wanna take a crack at it?

IIf(TX.TX_TYPE = 'R',
	IIf(TX.TX_MOSTYPE = 'P', 
		IIf(TX.TX_DEST_STATUS = 'A','PO Receipt',
			IIf(TX.TX_DEST_STATUS = 'U','PO Receipt Hold','Other')),
				IIf(TX.TX_DEST_STATUS = 'A','WIP Receipt',
					IIf(TX.TX_DEST_STATUS = 'U','WIP Hold','Other'))),
						IIf(TX.TX_TYPE = 'I',
							IIf(ISNULL(RTRIM(TX.TX_MOSJOB)) OR RTRIM(TX.TX_MOSJOB) = '','Shipment Return','Reverse Issue'),
								IIf(TX.TX_ORIGIN_STATUS=TX.TX_DEST_STATUS,'Loc Transfer',
									IIf(TX.TX_ORIGIN = 'SCRAPPED','Reverse Scrap',
										IIf(TX.TX_ORIGIN_STATUS = 'J','Count Adj Up',
											IIf(TX.TX_ORIGIN_STATUS = 'D','PN Change To',
												IIf(TX.TX_ORIGIN_STATUS = 'I','Reverse Unplanned Issue',
													IIf(TX.TX_ORIGIN_STATUS = 'A' AND TX.TX_DEST_STATUS = 'U','Hold',
														IIf(TX.TX_ORIGIN_STATUS = 'U' AND TX.TX_DEST_STATUS = 'A','Off Hold','Other'))))))))) AS [Transaction Type]