Hi
I need help with this query
I have a table which contains a bunch of fields
item , description, cost, date when the sale occurred etc etc
has a few thousand rows with each transaction on a different row
unique item is about 150
cost can be different for same item
i need to find the lowest cost on a particular item
so i made a totals query
grouped by item and used Min for cost
so far so good works fine
but i need to show when the last date that that item low cost occurred
Very important for me
also would love to show the description if possible
please help
David
I need help with this query
I have a table which contains a bunch of fields
item , description, cost, date when the sale occurred etc etc
has a few thousand rows with each transaction on a different row
unique item is about 150
cost can be different for same item
i need to find the lowest cost on a particular item
so i made a totals query
grouped by item and used Min for cost
so far so good works fine
but i need to show when the last date that that item low cost occurred
Very important for me
also would love to show the description if possible
please help
David