Right, I think I see what you're getting at now haha! :o)
Try this;
Group by table.Client_Name
Create a formula, we'll call is @uID;
@uID
totext({table.customerid},0,"")
& "-"
& totext(datediff("d",#01/01/1901#,{table.datefield}),0,"")
Now create a distinctcount on this field in your client name group,
If I understand you correctly this is what you want.
It merges the customer data with the date data to give a new unique customer id based on the date of the invoice.
IE in my previous example we'll assume the 2 customers are the only 2;
Client Alphabet would have a distinct count of 3 based on the following 4 records;
ABC-01/02/2012
ABC-02/01/2012
XYZ-01/01/2012
XYZ-01/01/2012
Let me know if I'm still not getting it haha! :)
Regards,
Ryan.
Edited by rkrowland - 28 Mar 2012 at 4:36am
IP Logged
