Hi Gail,

The reason this seems complicated is because the amount of the last unit price for an item for a customer is not stored in the database. Thus whatever report you create, this value needs to be calculated manually. It isn't as easy as it sounds.

Essentially, you are requiring a process to find all the sales for a particular customer in a date range, and the unit price for the most recent sale of each item. It is not important how many times the customer purchased the item, just that it was purchased at least once in the date range.

The Online Inquiry can show all the sales for a customer, but there are no selection filters for only the most recent detail of each item. This is why you are getting an 'average' price rather than the 'most recent' price.

Because the report you want to generate requires determining how many times an item has been sold to the same customer in a date range, you need a report tool that can filter out all the item sales except for the most recent one. Or a way to determine which item sale was the most recent and read the Unit Price from that.

This would be a fairly straight-forward thing to do with Crystal Reports, and no so straight-forward (if not impossible) to do with GridView or the Online Inquiry. The reason this is hard to do in GridView is that there are no formulas or functions to look at other records in the grid to determine which item sale was the most recent when there are more than one. And the available statistical operations in GridView are Total, Average, Min and Max. There is no First or Last statistical operation.