How can a query for the most recent date?

[lsanchez]

I have the following columns:

Date
Price
Item #
Item description
Weight
Cost

Now, what I need is a report that will give the last price of an item. I import the new pricing on to a table once I receive, but not all the items get new princing all the time. This means I can't query for the pricing of a specific date. I need to figure out a query that will give me the LAST or MOST RECENT price entered. Also I can't just sort it out without going through thousand of records to get what I need, that's what I've been doing so far.

Someone please help!!!!!!!!!!!!!

 

[Malcy]

Try DMax on the date field in a query to identify the most recent record.
You might need to set up a query to get the price.
Hope this helps

Good luck