Forums
This topic is locked
Eliminate Drop Down Box duplicates
Posted 03 Jun 2002 22:41:07
1
has voted
03 Jun 2002 22:41:07 chris cream posted:
I am building a search page and I want to search by the date field. The only problem is that when I do this there are multiple dates because of the multiple entries...how do I just search by one date...I am having the same problem with searching by someone's log in ID....if they log in more than once...there ID is in there twice....HELP...I am new to this Replies
Replied 04 Jun 2002 07:31:10
04 Jun 2002 07:31:10 Owen Eastwick replied:
Try usng a DISTINCT clause in the SQL statement used to create the recordset(s) that are used to populate the drop down boxes. Something like:
SELECT DISTINCT SomeFieldName FROM SomeTableName
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
SELECT DISTINCT SomeFieldName FROM SomeTableName
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo