Date sorted grouping query using last

[samcoinc]

Stupid qestion... I have some data that I would like to get the last price charged. I thought I could do it by first sorting by date in a query - then the next query - group by part and get the 'last' price. It seems though the sort is lost and the grouping query goes by the original table order.

Is there a way to sort the data in the grouping query? If there is I have not figured out the right way...

Access97

thanks a bunch!
sam

 

[samcoinc]

Ok - so it looks like I have to do it the old fashened way

2 queries...
First make a query that gets the max date for each part - then match that date up to to the original table to get the rest of the data for that date.

sam

 

[jdraw]

It would help if you described the issue and shown us the query sql that you are using.
--what exactly isn't working? Are you getting an error?

Need more info if we are to help.