Folks
Sorry for what may appear to be straight forward, but I'm struggling to find the answer.
I've a table of items purchased. which includes the dates of each and every item in the format dd/mm/yyyy.
I'm trying to run a query whereby it shows only the last date of the purchase, and it's asscociated cost at that time.
I've only 3 columns 'PARTCODE' 'RATE' 'DELDATE' with 'DELDATE being the date format column.
Could someone help me sort the query to show only the last date, I guess it's Group By, but group by what.
Access 2003 by the way.