formula

  • Thread starter Thread starter LindaA
  • Start date Start date
L

LindaA

how do I write a formula in an unbound textbox on a
report that will yield the most frequent number which has
been entered in a particular field in a particular table.
(The table's name is customers and the field is age)
 
You could do that using a find duplicates query, set the
fid duplicates to sort in desending order and show only
the top value.
Hope this helps
Fons
 
Back
Top