Can you group by last record or date in reports?
i need a report to show an item with the last date or record that i entered the item's price.
this is so i can have an updated inventory list of items with current prices.
tables: item_id, item, date, price, company
i was referred to this which i cant get to work.
You can group records in a report or on a data access page, based on date and time values. In Design view, set the GroupOn and GroupInterval properties to specify how you want the records grouped.
i have items with multiple records and prices. I just want the report to show the last updated price, item and company.
thanks
i need a report to show an item with the last date or record that i entered the item's price.
this is so i can have an updated inventory list of items with current prices.
tables: item_id, item, date, price, company
i was referred to this which i cant get to work.
You can group records in a report or on a data access page, based on date and time values. In Design view, set the GroupOn and GroupInterval properties to specify how you want the records grouped.
i have items with multiple records and prices. I just want the report to show the last updated price, item and company.
thanks
Last edited:
