Hi Tom, Don't know if I have your table structure correct, but try something like this:
sel vendor#, style#, sum(QtySold) from sales group by Vendor#, Style# ----- Original Message ----- From: TOM HART To: RBASE-L Mailing List Sent: Sunday, May 23, 2010 6:43 PM Subject: [RBASE-L] - Tally help 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
