0

I have a table containing the Items (code, name, prices), when I use Access database I can write a query (Query by Example-QBE) and pick all these columns and grouping them for the last one which is prices I can use last function in QBE and it will easily after running, it will show distinct values of items with the last value of prices...

But when I try to do that I shocked when I don't find a function name like (last()), and after searching it made it complicated for me.

Do you have any idea how to solve this?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Aso Salih
  • 1
  • 1
  • There are functions called `FIRST_VALUE` and `LAST_VALUE`; are those what you are after? – Thom A Aug 21 '22 at 17:59
  • Or perhaps you want the [top 1 row of each group](https://stackoverflow.com/questions/6841605/get-top-1-row-of-each-group)? – Thom A Aug 21 '22 at 18:00
  • provide sample data and show us your desired output – eshirvana Aug 21 '22 at 18:12
  • I want to make a short list of all items with the last price of them: lets say: itemCode:1,pen has the following prices:1,2,4,5 itemCode:2,book has the following prices:4,1,2,1 if I use access I will be able to retreive the following: itemCode:1,pen last price: 5 itemCode:2,book last price:1 but their is not such function – Aso Salih Aug 22 '22 at 14:36

0 Answers0