Hello George, SELECT * FROM tblContact WHERE fldLastName Like "A" & "*"
That's the query, as for the getting it onto a web page you'll have to treat it as e recordset. Not sure of the exact code but you can get it from an ASP group. Regards Robin --- In [email protected], "George" <[EMAIL PROTECTED]> wrote: > I seem to have some sort of mental block going on. I have a database > of personal contacts and I want to create a query that will grab only > those people whose last name starts with "A" or "R" or whatever. > > One final problem. How in the world do you get to this query from a > web page. I know how to display records from a database on a web page, > but I be darned if I can get my mind to wrap around how to get only > specific items from the same database, hence the desire for a query. > > Thanks in advance. > > Stuck ------------------------ 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 <*> 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/
