Show item with last updated price by date

[drossie]

Show last date items and prices

I need a (group by?) query that shows my items only by the last updated price by date.

Basically i need to show the last date. (MaxDate?)

I keep a database for my restaurant of my food items and change their price everyday. i now have a table that archives individual items by date, price and company in a subform.

Item_id , Item , date , cost , unit , Company

1 asparagus, medium 8/12/2005 $1.45 pound Euro Gourmet
1 asparagus, medium 8/13/2005 $2.00 pound Euro Gourmet
55 oil, blended 8/12/2005 $4.99 gallon accardi
116 polenta 8/12/2005 $1.58 box accardi

I am trying to kick out an item or inventory sheet by creating this query but i cant seem to group by last date. i have all my items showing up multiple times (as many as i entered)
i have been easily able to create an inventory report off a query i used with only one date that i would change. but now i want to archive prices for charts.

i have tried max dates on item_id fields and date fields and nothing seems to work.

Thank you

 

[ThreeCrow]

In you Group By Query have you tried Last. insread of max.

 

[drossie]

last date query

i need for it to be updateable. i change the prices every day as the invoices come in.
can i group by last date in a report?

can i group by last record. that would work too.

thanks for response