Drop-down menu requiring distinct field values

[Guest]

The KB article 265307 recommends using the following SQL statement (at the end of the article) when one desires for a drop down menu to display only distinct field values: "SELECT DISTINCT field name FROM table name". How/where do I add this. My drop down menu is actually the results of a view/query in Access. Should the SQL language be in Access or in Front Page? My experience with Access is that to get distinct values I would need a sub-query and I'm hestitant about adding this complexity. I have no idea as to where I would insert it in Front Page (my understanding is that FP would over-right and text added in the HTML view). Please advise. Thanks! Bob

 

[Jim Buyens]

If you're using the Database Results Wizard, you would
enter the SQL statement after advancing to page 2 of the
wizard, then selecting Custom Query and Edit.

A SQL statement of the form:
SELECT DISTINCT field FROM table
should work fine with Access.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Guest]

Your recommendation work. Thanks! Bo

----- Jim Buyens wrote: ----

If you're using the Database Results Wizard, you would
enter the SQL statement after advancing to page 2 of the
wizard, then selecting Custom Query and Edit

A SQL statement of the form
SELECT DISTINCT field FROM tabl
should work fine with Access

Jim Buyen
Microsoft FrontPage MV
http://www.interlacken.co
Author of
*---------------------------------------------------
|\--------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Ou
||--------------------------------------------------
|| Web Database Development Step by Step .NET Editio
|| Microsoft FrontPage Version 2002 Inside Ou
|| Faster Smarter Beginning Programmin
|| (All from Microsoft Press
|/--------------------------------------------------
*---------------------------------------------------