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.