Re: Drop Down List

From: TJ (TJ_at_max.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 02:04:25 -0500

Just guessing here, but what you might need is a Custom Query.
Copying from another Post (SELECT DISTINCT Query not working)

> "SELECT DISTINCT Maincategory FROM Results"
> "Results" being the table.. "Maincategory" the column (Field name)

This is the correct answer. For future reference, let me tell you why:

The DISTINCT Operator in SQL ensures that records that are identical are
combined into single records. Note that I said "records" not "columns." This
means that if you select more than one column in a record set, ALL columns
selected must be the same in order for 2 records to be combined. When you
use "SELECT *..." you are fetching ALL columns from the table, not just the
"Maincategory" column, and if, for example, that table has a primary key
field, such as an AutoNumber field, that field will not have the same value
in both records, and they will not be combined. 

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living
-------------- Snip -------------------
|
| Speaking of that, I still haven't gotten my duplicate record problem
solved
| yet.
------------Snip----------------------