Here is what I am looking to do: In a table Inventory I have a column for Vendor#, Style#, etc, and when sold will go to Sales. I want to tally Style# by Vendor# for sales and inventory. Help says you can use tally in a view but I can't seem to get it to work. Ultimately I want to print a report of both tally's by Vendor, but I can't seem to get it in a view or temp table. Tom Hart
