Filtering in a report

[George]

Good Afternoon,



In my report there is a field with a number of numerical value. I want the report to show those numbers that are more than 2 only. Can you help me how this can be done?


Thank you

[pbaldy]

You could use this method:

http://www.baldyweb.com/wherecondition.htm

and either hard-code the 2 or refer to a form so the user can choose.

[George]

My concern may have been missed understood. Here is it again: I have a field called "Course" and another "Number" representing the number of students registered for the various courses. I want the report to exclude courses which are undersubscribed i.e. below 5 students.

[pbaldy]

And my suggestion didn't work? OpenReport with a wherecondition of "Number > 4".

[George]

Your example speaks to a field name and a control name; however since it is a calculated control, which is summing, it does not have a field name only a control name. The expression in this control is "count(*)" which counts the number of students registered for various courses listed in the course field.

Additionally, can this task be done through a macro instead?

[pbaldy]

I was thrown off by:

I have a field called "Course" and another "Number"

If you can move the calculation to the report's source query, that would give you a field to use. If not, you can probably use code in the appropriate section(s) of the report's format event to make them visible or not based on the count. If you can post the db, it may help.

[George]

Unfortunately the file is to large to upload, also my report is based on the table, there is no query. Can this task be done through a macro?

[pbaldy]

It's possible, but as I don't use macros I'm not sure; sorry.

[George]

ok thank you