>>I am trying to build a view that totals an amount filed, I wish to have one column total be a YTD total and another column for just a particular day. I have tried using a join but that gives two rows for the result, I need one row with both totals.
>>
>>TIA
>>
>>Ian
>Make that a union not a join

Union gives you new row(s). Do you really want to have columns? Could you post a sample of wishful query results.