Pls help.
I am trying to find a way to get the code similar to last() function in access. I got a table recording prices of different items (autonumber, item name, item price) and need some thing to get the last price for each item.
All I can do now is to build a 2 steps:
1- Get Max autonumber for each item
2- Get Price @ the Max autonumber of step 1
Thanks.
I am trying to find a way to get the code similar to last() function in access. I got a table recording prices of different items (autonumber, item name, item price) and need some thing to get the last price for each item.
All I can do now is to build a 2 steps:
1- Get Max autonumber for each item
2- Get Price @ the Max autonumber of step 1
Thanks.