The report can range from 2 - 6 pages.
Ok I found a way to do this by using filter....but I'm not very good with VB coding...please help.
Right now the code is:
Me.FilterOn=True
Me.Filter = " conditions/criterias "
In the table that the report reads, there are fields such as YEAR, REQ COURSES, SESSION, GRADES, etc.
For my condition I want YEAR = 1, YEAR = 2, YEAR = 3, GRADE < 50 % or Grade = " F " and so on...
But when I do
Me.Filter= "YEAR=2"
Access complains about the code.... could someone help me on how I could set the conditions/criterias for the filter using VB code? Also how do I use AND, OR and stuff like that on coding?
How do you use OpenReport/PrintOut methods?
Me.PrintOut= "2" - > page 2 ?
Thanx.
