OK John! It worked, I think I did not have the ()'s before. I wouldn't mind building a form, but when I tried with the directions I found, they were apparently for a different version because I did not get the expected next screen. I would do step 1, say, then it said I would see bla, bla, bla, but I saw something else entirely. I tried to follow the next logical step, but never quite got there. I chickened out after a few steps because I was afraid I would mess up what I already have that works reasonably well. I might not be so afraid, but I really don't understand all the relationships of forms to tables, to reports etc. Susan
-- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> wrote: > > Susan- > > The general technique with Null parameters is to put something like this in > the Criteria of your query: > > [Enter Student Number] Or ([Enter Student Number] Is Null) > > If you do too many of these, you could get a "query too complex" problem. > The solution is to build a form to hold the parameters and write code behind > the form to evaluate the parameters and build a custom filter for your > report. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Susan Gardner > Sent: Wednesday, October 26, 2005 5:43 PM > To: ms_access@yahoogroups.com > Subject: [ms_access] Using parameters with queries and reports > > I have a table with a columns that are called "Status", "Grad Year" "Student > number" & "Name" to name a few. I have a letter/report that prints out for > each name. I have things set up so when I want to print the letters/create a > report, I am prompted for the status, and their grad year. I finally figured > out that I could use Between [start with grad year] and [end with grad > year]. This is a step closer than I was before. But... is there a way I can > be prompted for their student number, but if I want all students I can leave > all or any prompts blank? I want to be able to create letters on the fly > without having to answer all 5 or 6 questions. In other words, if I don't > answer the prompts, I want the works! But all I get is the skeleton of the > letter with NO data. > I saw something about using "Null", but I couldn't seem to make it work. > I have Access 2002. I think I found something on 2003, but the steps in the > instructions did not work as expected in my program. > > > > > > ------------------------ Yahoo! Groups Sponsor -------------------- ~--> Fair > play? Video games influencing politics. Click and talk back! > http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM > ------------------------------------------------------------------- -~-> > > > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> 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/
