PDA

View Full Version : Drop Down List Menu Problems: DataAssist

fabianmacs370894
07-10-2009, 04:07 PM
I have created a dropdown list in a search page that allows me to select a month from a list and then it displays the results from all events in that month. Problem is that because there is multiple records in various months the dropdown list shows eg. July 3 times. I want it just to show July once and then display all results from that month.

Any help on this would be much appreciated.

Thanks ia advance.

Fabian
fabianmacs370894
07-10-2009, 05:02 PM
Problem solved, I had to use SEARCH DISTINCT Month in my search results recordset.
nunez_r336980
02-25-2010, 01:42 PM
Problem solved, I had to use SEARCH DISTINCT Month in my search results recordset.

I'm having this problem, could someone give more detail exactly how to do this? Thanks.
nunez_r336980
02-25-2010, 02:16 PM
never mind I figured this out. The above should have read "SELECT" of course not 'search'