Access fixes things for you, so if it took what you did and made it into three rows, and your report worked, leave it alone.
Inside your query, under the field for your Grad Year, in the criteria field, type in "IS Null or [Enter a Graduation Year]" (without the quote marks). Now when you run your report, you should get a prompt which comes up and says "Enter the Graduation Year", you can then type in a year and get only those records when you click the OK button, or you can leave it blank (IS Null) and have all the records returned. Access may fix it to have two columns of Grad Year, one with IS Null in the Criteria, and one with [Enter Graduation Year] in the Or row. Dawn Crosier Application Specialist "Education Lasts a Lifetime" This message was posted to a newsgroup. Please post replies and questions to the group so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Gardner Sent: Friday, March 24, 2006 12:31 PM To: [email protected] Subject: [ms_access] Re: Report using or all if null The Criteria is what I was looking for. Do you mean that I put "IS Null or [Enter a Graduation Year]" all in one box on the row where Criteria is or across from where the "OR" is? or some in each box? After I entered what ever I had entered in the report that works, when I go back there are 2 or 3 rows of the same thing. When I tried to make just one row, the report didn't run correctly at all. Susan G Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
