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

Reply to this topic