>>>>>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.
>>
>>The view is to show the amount of a commodity delivered to a warehouse both YTD and today
>>
>>Commodity YTD delivered Today delivered
>>Wheat 99999 11111
>>
>>Ian

Firstly, excuse me for empty reply. Secondly, what do you have in base table? Do you have multiple commodities? It seems to me that cross-tab query will be part of solution.