John, I have a book by Virginia Anderson "How to do Everything with Access 2000" I could not find what you are talking about in her book. So I'm really at a loss. Is there any more you can tell me about this SQL business that might get me started? TIA Susan
--- In [email protected], "Susan Gardner" <[EMAIL PROTECTED]> wrote: > Thanks, but this is so far over my head, I have not a clue how to do > what you are saying. I know what a basic query is, but not the other > terms. I am going to borrow a book from a friend here in a minute, and > see if I can find the terms and go from there. I'll let you know if I > figure it out or not. I don't even have Access on my computer at home > and tomorrow is my last day at work for the summer. I might see if I can > get a copy to play with at home. > Thanks, > Susan G > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of John Viescas > Sent: Saturday, June 18, 2005 6:53 AM > To: [email protected] > Subject: RE: [ms_access] Re: Report > > Susan- > > You need to build a custom "query by form" unbound form that contains an > unbound control for each criteria you might want to apply to the report. > Write code behind a command button on the form to examine what criteria > were > entered and dynamically build a filter (like an SQL WHERE clause). Use > that > filter in the WhereCondition parameter of the OpenReport action to open > any > report so that it displays only the records that match the criteria. > > John Viescas, 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/
