combobox - removing duplicates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neil M - 31 Oct 2005 14:07 GMT

Is there anyway to remove showing duplicate records ina subform linked to a
query

The query just shows NAMES in AZ order from the table, but I dont want the
combo to show duplicate names?

Thanks.

Neil

Reply to this Message

Klatuu - 31 Oct 2005 14:16 GMT

Make your query a Totals query and use a Group By on the names.

> Is there anyway to remove showing duplicate records ina subform linked to a
> query
[quoted text clipped - 5 lines]
>
> Neil

Reply to this Message

Brendan Reynolds - 31 Oct 2005 14:23 GMT

Neil, your subject line says 'combobox', but the body of your message says
'subform'.

If a combo box, you need to modify the row source property, if a subform,
you need to modify the record source property. Either way, if the property
is referring directly to the table, change it to a SQL statement using the
DISTINCT keyword like so ...

SELECT DISTINCT YourFieldName FROM YourTableName

Here's a link to the relevant on-line help topic ...
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP010322051033

Signature

Brendan Reynolds

> Is there anyway to remove showing duplicate records ina subform linked to
> a
[quoted text clipped - 6 lines]
>
> Neil

Reply to this Message