Hi, I am using a report in Microsoft Access to try and display the most occuring customer number in a table, i have looked in the expression builder and there does not appear to be a mode average function, is it actually possible to calculate the mode average in Access? and if so how? Cheers for any help Lee

Hi, I am also trying to figure this out. Any suggestions you guys have would be greatly appreciated. I too am using a report with Access and need it to calculate the most occuring number in a field in a table. Thanks for your help.

Which version of Access are you using? I know Access 2002 query wizard lets you create a query that shows the count of each number in the field. You can have it display just the top one. More info here from google groups post: I have a make table query that counts the number of each item in a list and sorts them in decending order by count. So the results is something like: This Item 125 That Item 92 Other Item 85 And This Item 75 etc...... This list is about 135 records long. I only want the top ten. How can I specify to only return ten most occuring number of items? tod Open the query in design view/click view/Click properties/In the top values field...key in 10 lin I don't see the field you are refering to. I opened the query in design view, clicked view and then properties, but no top values field. What am I missing? tod Try it this way..... Open in design view/RIGHTclick on the gray area behind the tables or queries that make up your query/ then properties....dadadada top values will be there