I have a simple table of invoice data. Screenshot below.
I want to show on screen the fields: Sum_Sales, Sum_Profit, Sum_Cases
I want the user to be able to enter in a to and from date and the data on screen change to match only the sums for invoices in that date range.
I would also like user to enter a salesman number and see sums of invoices only associated with that salesman number.
I don't want to use a portal, I just want to see those fields.
Can anyone give me advice on the simplest way to do this?
Thanks a bunch for any help.