Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Need help with date range


kpratt2345
 Share

Recommended Posts

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

 

My mail order relational database. I have 3 main files: customer, sales order and inventory . Customer and sales order are related thru the customer ID number. Sales order and inventory are related by the invoice ID number. Customers have multiple records in sales order for repeated purchases. The field I am looking to calculate is a date range that shows the first sale date and the last, thereby displaying the customer's purchasing history. I need to display this in a customer summary list, already existing in the 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? :)

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use