Buddy, Its actually more complicatd than that. I am trying to generate a report to show whats been billed, paid, and canceled by month. My problem is the billing amount uses one date (InvDate) and the paid and canceled uses another (PayDate). I want those figures to all go under the same month. I have set up 3 different views - DuesBill, DuesPaid, and DuesLost. DuesBill is (tmon(InvDate)) and (sum(InvAmt)) DuesPaid is (tmon(PayDate)) and (sum(PAamt)) DuesLost is (tmon(PayDate)) and (sum(InvAmt))
what I am trying to do is combine all three views into one so I can look at these figures by month. The new view would consist of: DuesMonth,BillAmt,PaidAmt,LostAmt every time I try to combine these views I keep getting the illegal column specification! Any thoughts are appreciated!!! Jan
