Hi Agnes, >Hi Erick, > >thanks for your response. >Possibly I do express myself wrong. > >The question is: >The records for the last (IOW greatest) five dates per customer. The value is in no way bound to date. >The date field is in no way ordered or the date will >follow any rule. There may be 1 to n records per user. Every day may exist only once per customer. (customer+date may create a candidate key). > >Agnes
OK. I saw Fabio's answer. I hope to help in the next time. 8-D
