Search results

I'm making a query that has the following Fields Product (Table PDZRN1) Whse (Table PDZRN1) Description (Table PDZRN1) On Hand (Table PDZRN1) Unit Cost (Table PDZRN1) Unit Price (Table PDZRN1) LastDate: Date (Table Sales_History) (using the Max function) Where I am stuck is I want 4 additional...

I have purchase history that contains multiple part numbers, multiple customers with multiple purchase dates. I'm trying to extract the min date and the max date that each customer may have purchased a particular part number. I was thinking I could do this with a query, but I'm running into...