hide fields from being previewed by a specified report. Check d pic for illustration

[chris92]

Please i have report that i want to filter failed courses but i want the failed courses to be hidden when passed by the student. I dont want the course failed to removed because it ll be used some other place but want to hide it in the failed course report if passed. Thanks as i expect your help.

All the results are in from one query. There is an illustration pic: "illustration_1"

 

[RainLover]

In your query you would enter as Criteria <> F.

Or is there more to your question.

 

[chris92]

Yes, it is supposed to be "< F " but the report will show the failed courses' even when its been re-written and passed. It has to filter the F if the course has not been passed.

 

[RainLover]

Can you create and post a Table with some sample data. Also include your query even though it does not work.

In the table add an extra Field and place an "S" for show against the records you want to show in the query.

Please use Access 2003.

 

[Pat Hartman]

You need to create another query.
qry1 -
A totals query that counts the number of "pass" grades by student and course. Add criteria that selects only rows where the count is 0.

Join this query to the one you are currently using. It will eliminate all courses that have been passed at least once.

 

[chris92]

Hi Pat, Am SORRY for opening double threads on one topic. I never knew it was not allowed

 

[Pat Hartman]

Opening multiple threads isn't disallowed but it does cause unnecessary work for those of us who are trying to help you. Everyone doesn't read every thread so if you have multiple threads on a topic, someone might spend an hour trying to find a solution only to find out later that someone else provided a solution in a different thread. As you can imagine, that person would not be happy about wasting his time on your behalf. If you elect to start another thread, post links in both so that people can easily see the other thread.

 

[chris92]

Ok i understand completely.