Susan- You'll find more info in books like "Using" by Roger Jennings, "Bible" by Cary Prague, or my "Running" or "Inside Out" books. If you really want to learn SQL, take a look at Melton's "Understanding SQL", Groff & Weinberg's "Lan Times Guide to SQL", or my "SQL Queries for Mere Mortals." Go spend an afternoon in a bookstore that has a good computer book section, browse through several titles, and pick the ones that "speak" to you.
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: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Susan Gardner > Sent: Monday, June 20, 2005 11:36 AM > To: [email protected] > Subject: [ms_access] Re: Report > > > 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 > > > > > 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/
