need help with date range

[Dragon Lady]

You guys have been so helpful already, so here is my next dilemna…

My mail order relational database. I have 3 main files: [color:blue]customer, sales order and inventory. [color:blue][color:black]Customer and sales order are related thru the customer ID number. [color:black][color:blue]Sales order and [color:blue]inventory are related by the invoice ID number. Customers have multiple records in the [color:black][color:blue]sales order file for repeated purchases. The field I am looking to calculate is a date range that shows the first sale date and the last, there by displaying the customer's purchasing history. I need to display this in a customer summary list, already existing in the [color:black][color:blue]customer database, displaying summarized purchases and number of orders. Or two fields for one customer ID# displaying the first order date and the last order date.

I have seen some solutions for this - but they are pretty complicated and I don't want to use up resources with huge calculations and tables.

Any ideas out there? :)

[comment]

Assuming that your sales orders are created in chronological order, and that the relationship is not sorted, the first order date would be SalesOrders::Date and the last order date would be Last ( SalesOrders::Date ) .