Does anyone have a query or is there a report that would show lifetime tickets purchased sorted by dollar amount? You would probably want to reduce by any ticket refunds. We want something like:
ID 21314 Bill Smith $168,222
ID 1918 Jane Doe $144,326
etc.
Phil
Your ticket history table may be customized but you can give this a whirl:
select a.customer_no,sum(a.tck_amt) as total_dollars,b.fname, b.lname
from lt_tkt_hist a
join t_customer b
on a.customer_no=b.customer_no
group by a.customer_no, b.fname,b.lname
order by total_dollars desc