satyen
02-24-2010, 02:12 PM
Hello.
I have a set of numbers i.e.
5555
4444
4444
23411
2345234
55555
4444
Is there a function in Ms Access that I can use within a query- not code so that it calculates 5 as the answer using the dummy data above for example.
I know you'd need to Sort firstly. There is a formula in Excel which I have used and it works, but need the equivalent for MS Access, if anyone knows?
Many Thanks in advance.
I have a set of numbers i.e.
5555
4444
4444
23411
2345234
55555
4444
Is there a function in Ms Access that I can use within a query- not code so that it calculates 5 as the answer using the dummy data above for example.
I know you'd need to Sort firstly. There is a formula in Excel which I have used and it works, but need the equivalent for MS Access, if anyone knows?
Many Thanks in advance.