Recent content by Irons182

Great thanks! If I wanted to sum values, albeit one might be null i am getting an aggregate error with the following statement. SELECT [TBL: Sales].[Transaction Date], "Online" AS Channel, "Peter" AS Name, "PlusBD" AS Product, Sum(Nz([Peter_Online_PlusBD])+Nz([Peter_Online_PlusLE])) As Sales

Thanks, any chance you could give me an example? I've tried UnionAll but can only get one column as I want it.

Hi all, I have a table set out as below. I am trying to get the column headers separated and into rows. Any help greatly appreciated! Thanks Current: Date -- Peter_Inbound -- Peter_Outbound -- Andy_Inbound -- Andy_Outbound 1/1/2017 -- 5 -- 10 -- 16 -- 4 2/1/2017 -- 7 -- 16 -- 12 -- 9 etc...