By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,156 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,156 IT Pros & Developers. It's quick & easy.

Limit information on report based on "Count"

P: 1

I have the following data in a table:

From To
a to b
a to b
a to c
b to c
b to c
etc etc etc

On a report I have a function that counts the number of instances from a to b, a to c etc. I want to limit the report to show only records where the count is above a certain value. For example in the above example a to c only occurs once so I want to discard that data in my report.

I guess that the data has to be filtered somehow in a query but have not idea how to do this.

Thanks for any help.
Oct 29 '06 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
Assuming your data is stored like this ...

Expand|Select|Wrap|Line Numbers
  2. From        To
  3. a            b
  4. a            b
  5. a            c
  6. b            c
  7. b            c

SELECT From, To, Count([From] & [To]) As countInstance
FROM tableName
WHERE Count([From] & [To]) >1;
Oct 29 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.