I am in need of some assistance and hope someone out there can help me!
Each of our company's members renews in a different month each year, and when they come up for renewal, the db creates an invoice for that member for the 1st of their renewal month.
Sometimes I am asked to run a report of all members and other customers who are no longer active, along with the last dues amount they were ever invoiced for, regardless of the year. Could I do this with a "Top N" summary? I couldn't specify a date range because I need the last invoice they ever received, regardless of the year in which it was generated.
I have a column in the invoices table, which is Invoice ID, that gets automatically assigned to each record when the invoice is created. I know one way to achieve what I need is to say I need the highest invoice ID for each customer, but I don't know how to do that :( Would that be Top N where N is "1" based on Invoice ID? And if so, how would I insert a summary on this so that the Group Sort function would even be available?
IP Logged
