Narrowing a search

[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

[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

[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

[BobWeaver]

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

[BobWeaver]

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

[BobWeaver]

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

[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

[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

[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