Hi all

I need to create a mailshot to all my customers who have had an estimate in a specific time period. When I execute the find it shows that some of these customers have had more than one estimate during this time. In this case I need to show the last estimate for the customer. Anyone have any ideas how I can do this? 2 files: customer and estimate.

Many thanks in advance for your help

eSBee

Hi all

I need to create a mailshot to all my customers who have had an estimate in a specific time period. When I execute the find it shows that some of these customers have had more than one estimate during this time. In this case I need to show the last estimate for the customer. Anyone have any ideas how I can do this? 2 files: customer and estimate.

Many thanks in advance for your help

eSBee

Hi all

I need to create a mailshot to all my customers who have had an estimate in a specific time period. When I execute the find it shows that some of these customers have had more than one estimate during this time. In this case I need to show the last estimate for the customer. Anyone have any ideas how I can do this? 2 files: customer and estimate.

Many thanks in advance for your help

eSBee

In the customer file layout, show the related invoice date field. Then, do the date range search in that field from the customer file.

In the customer file layout, show the related invoice date field. Then, do the date range search in that field from the customer file.

In the customer file layout, show the related invoice date field. Then, do the date range search in that field from the customer file.

Thanks for your suggestion.

I resolved the problem yesterday by performing a search and sorting it, then checked if the current and next records were for the same customer and omitted the current record, referred to above, if true.

Many thanks

eSBee

Thanks for your suggestion.

I resolved the problem yesterday by performing a search and sorting it, then checked if the current and next records were for the same customer and omitted the current record, referred to above, if true.

Many thanks

eSBee

Thanks for your suggestion.

I resolved the problem yesterday by performing a search and sorting it, then checked if the current and next records were for the same customer and omitted the current record, referred to above, if true.

Many thanks

eSBee