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
--- In [email protected], "Crosier, Dawn" <[EMAIL PROTECTED]> wrote: > > 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: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Susan Gardner > Sent: Thursday, March 23, 2006 11:59 AM > To: [email protected] > 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/
