prob a stupid question

  • Thread starter Thread starter brian
  • Start date Start date
B

brian

If I am doing a simple select query against a SQL
database and want to be sure that one field contains only
a distinct value, how can I do it without writing the
query in SQL?

thx
 
Hi,


The easiest way is to add the word DISTINCT in the SQL view, right after
the SELECT and before anything else in the list of the stuff you select. But
for some obscure reason, it seems you forbid yourself to use the easiest
way, so, graphically, it would be to get the property sheet of the query,
which is available if you right-click on a free space on the top portion of
the query designer, and then, change the property Unique Values to yes.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top