Newbie to query

[ruthndul]

Hi, I'm new to MS Access,

Having difficulties with queries, to show the most recent price from a table like below:





Query design view:


Query result:



Which is not correct.
It is supposed to be

Orange $6 as of 5/5/22
Apple $0.5 as of 5/6/22

Can someone help please?

Thank you in advance.

[pbaldy]

Welcome to the site. Your images didn't come through, so maybe try again? Or post the SQL, somebody may get it from that.

[ruthndul]

Here is the screenshot.

[pbaldy]

I think you need something like this:

http://www.baldyweb.com/LastValue.htm

It can be done as subquery, but in my view easier to view as 2 queries.

[ruthndul]

Thanks pbaldy,
Can you elaborate more how does 2 queries work to solve this issue?

[pbaldy]

I thought I did, but the first query finds the latest date per item, the second uses that to find the other information from that record.

[ruthndul]

I figured out...
I did the 2 queries.
thanks for the clue pbaldy

[pbaldy]

Happy to help!