Jump to content

need help with date range


Dragon Lady
 Share

This topic is 5736 days old. Please don't post here. Open a new topic instead.

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: [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? :)

Link to comment
Share on other sites

This topic is 5736 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.