Number querie

[Rigsby]

Hoping someone can help me here.
im trying to create an expression to generate 5 highest numbers from twelve number fields (N1-N12), preferably each of the 5 high numbers will be entered into its own new field (H1-H5)

It looks an easy task but i really dont know where to begin and any help will be very much appreciated.

Thanks
Kevin

[Rixxe]

Search google for: 'Sql MAX Function' and 'Select TOP 5'.

These are some suggestions, as it sounds like the kind of thing that you need to head in the right direction.

Good Luck Kevin.

[orange]

You could store the 12 numbers, sort them ascending ,and pick only the last 5.

If you had an array x(11)
Put the sorted numbers into x(0)....x(11)
then in a loop
for i = 0 to 4
pick x(i)
and save it where you want
next i

Again, this just an approach

[thhui]

This is indeed a transposer question.
See the suggested answer from microsoft access website.

http://support.microsoft.com/kb/182822