criteria to filter form to only recrds which have had a field peviously filled (1 Viewer)

[Happy YN]

I have a cmd button which appends blank records for a school class against a test name and then runs a query to show these results ready for entering a mark etc.
How do I get the form to only show those pupils who have previosly had a mark for an earlier test in this subject -is it applying a filter or modifying the sql for the underlying query? and how top go about this?"
thanks

 

[cogent1]

Do you want to be able to choose a subject and display a mark sheet on demand, or display all the mark sheets together, by subject?

If the former, you need to open a form WHERE:

Mark is not Null AND Subject=Chosen Subject.


You can do this with an SQL Statement or a saved Parameter query (with Subject being the parameter you need to supply). It doesn't really matter.

If it's the latter option, you only need a straight query, ordered by subject.