Yes, I know Access97 is outdated and very old - but bear with me. We have two tables. One holds the sales order header file such as the sales order and the customer name. The other holds the sales order detail file - the individual line items on that sales order and information such as the part number, qty, date.ordered, & date.shipped.
Example
SOH_Header -
so_number 12345
SOH_Detail -
so.nbr 12345
line.nbr 1
date.ordered 09-01-08
date.shipped 09-02-08
so.nbr 12345
line.nbr 2
date.ordered 09-02-08
date.shipped 09-04-08
so.nbr 12345
line.nbr 3
date.ordered 09-03-08
date.shipped 09-03-08
I need to create a query that will pull the earliest date.ordered field and the latest date.shipped field for this sales order and all other sales orders created this year. I'm thinking I may need to have a query running a subquery but I'm not sure of the joins.
Example
SOH_Header -
so_number 12345
SOH_Detail -
so.nbr 12345
line.nbr 1
date.ordered 09-01-08
date.shipped 09-02-08
so.nbr 12345
line.nbr 2
date.ordered 09-02-08
date.shipped 09-04-08
so.nbr 12345
line.nbr 3
date.ordered 09-03-08
date.shipped 09-03-08
I need to create a query that will pull the earliest date.ordered field and the latest date.shipped field for this sales order and all other sales orders created this year. I'm thinking I may need to have a query running a subquery but I'm not sure of the joins.