this works great TY!

however for some reason when i tried the query as posted, the numbers were off. (couldn't figure out why)

but when i changed it slightly to

select sum(col1)...

i tried this, but it doesn't work at all... says i have to start with "select" etc...

does this kinda of sql work in access?

oh man... thanks...

i'm retarded - just didn't realize at first that that's the same thing...

tyvm lynn

ok here is my statement in entirety

SELECT DISTINCTROW [tblTraderNames].TraderName, (Sum([tblTraderPnL].[Net P&L]))*(.9) AS [Money] , 'Net P&L' AS [Memo]

INTO tblTempReportNetPnL

FROM (tblTraderNames INNER JOIN tblTraderPnL ON tblTraderNames.TraderID = tblTraderPnL.TraderID) INNER JOIN...