PC Review


Reply
Thread Tools Rate Thread

common entry reporting

 
 
Jeff
Guest
Posts: n/a
 
      28th Feb 2006
Hi all
I am hoping someone will be able to help me, I need to have a sheet set
up, so when a button is clicked it generates a report that indicates the
5 most frequent results in a column and reports it to a second sheet.
ie if number is 3256 and it appears 5 times in column, and 2345 appears
3 times etc.. this will become data in second sheet.
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      1st Mar 2006
Any more info?
1) range of numbers
2) duplicate frequency possible?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jeff" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi all
> I am hoping someone will be able to help me, I need to have a sheet set
> up, so when a button is clicked it generates a report that indicates the 5
> most frequent results in a column and reports it to a second sheet.
> ie if number is 3256 and it appears 5 times in column, and 2345 appears 3
> times etc.. this will become data in second sheet.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to find the most common occurance/frequency of a field entry Chris K Microsoft Access Queries 1 9th Aug 2010 11:32 PM
VLOOKUP-common look up entry with multiple results =?Utf-8?B?Q3JpbXNvblBsYWd1ZTI5?= Microsoft Excel Worksheet Functions 3 11th Aug 2007 06:34 PM
creating Time & Expense entry / reporting system P.Schuman Microsoft Outlook Form Programming 1 26th May 2007 08:36 AM
Reporting grouping dropping duplicate entry. =?Utf-8?B?aWhvbGRlcg==?= Microsoft Access Form Coding 4 9th Aug 2004 04:45 PM
Re: sharing a common form among data entry people Rick Brandt Microsoft Access Forms 0 16th Mar 2004 08:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:44 PM.