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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set value of a text box conditionally 2
Excel How to get the number of days an item was opened from the today's date. 14
report with several unbound fields 2
copy format and formulas of one report to a second report 2
Access 2003 - calculating age 3
How can I addition a quantity in a text box 6
Access Counting records based on multiple age bracket and output to tabulated report 0
Report with percentages of total 2

Back
Top