Open your report in Design View. Open the Properties for the report. Look at the record source of the report. Is it based on a query? If it is, then you can modify the query so that you will get a prompt every time the query or report is run. Inside the query builder, change the criteria for "grad year" to
IS Null or [Enter a Graduation Year] 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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Susan Gardner Sent: Thursday, March 23, 2006 11:59 AM To: ms_access@yahoogroups.com Subject: [ms_access] Report using or all if null I not proficient at Access, but I have a question. Someone built an entire file for me, so what I'm trying to do is refine it a bit to make it more useful. That is why I seem to have something rather complicated, but have no real idea as to how to do this myself. I have a table that has a column called "status" then another one called "grad year." I have a REPORT that I want to give me all data for those whose status is "current" But.... I also want be prompted for their grad year. In that grad year box, as it pops up, I want to either put in a particular year, or leave it blank so I can get a report that gives all grad years. I did this on another report (with help) and was trying to look at how that was done so I could do it in this new report, but what I see seems to have changed after I build the report so that I can not refer to it now. The old one works, but I can not copy what is there now into my new report. I hope this makes sense, because I really need help with this. 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/
