<div>
Seems simple enough but.... I have an issue with my field that am trying to search. &nbsp;When I create the listbox, I select the table and then that one field. &nbsp;When I advance to the next screen that allows me to set the sort order for the field, it has also pulled the PK into the query. &nbsp;If I remove the PK from the query, I do not get any results. &nbsp;If I leave it in, I still have all of the date results (I am guessing because the primary key is distinct).<br />
<br />
I am trying to fix a db someone else started. &nbsp;Is there a way to separate the date field from the PK?<br />
<br />
Thanks.
</div>


Seems simple enough but.... I have an issue with my field that am trying to search.  When I create the listbox, I select the table and then that one field.  When I advance to the next screen that allows me to set the sort order for the field, it has also pulled the PK into the query.  If I remove the PK from the query, I do not get any results.  If I leave it in, I still have all of the date results (I am guessing because the primary key is distinct).

I am trying to fix a db someone else started.  Is there a way to separate the date field from the PK?

Thanks.

<div>
It worked perfectly. &nbsp;I just had to change the source of my form. &nbsp;Thank you!
</div>


It worked perfectly.  I just had to change the source of my form.  Thank you!

<div>
<div class="content wysiwyg-content">
I have a query that I am running based on one of the fields in the table. &nbsp;I don't want to rely on users to enter the date in the correct format so I have it set to create a list box with the values found in the field but since it is a date field, I have many duplicates. &nbsp;How can I filter the list box values so that each value is only listed one time?<br />
<br />
i.e. &nbsp;Field contains 26-May-09, 26-May-09, 26-May-09, 25-May-09, 25-May-09, 24-May-09<br />
<br />
List box would contain:<br />
26-May-09<br />
25-May-09<br />
24-May-09<br />
<br />
Thank you.
</div>
</div>


I have a query that I am running based on one of the fields in the table.  I don't want to rely on users to enter the date in the correct format so I have it set to create a list box with the values found in the field but since it is a date field, I have many duplicates.  How can I filter the list box values so that each value is only listed one time?

i.e.  Field contains 26-May-09, 26-May-09, 26-May-09, 25-May-09, 25-May-09, 24-May-09

List box would contain:
26-May-09
25-May-09
24-May-09

Thank you.

Access Filter a List Box so no duplicates

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.