Using DISTINCT in Query Grid 1

[SkipVought]

Hi gang,

I know that I can go into the SQL and modify my Select clause with

Select Distinct Field....

Is there a way to do that from the Query Grid?

Dumb as a POST

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[RobCPA]

In the design view, open up the query properties (View->Properties). Make sure the box that pops up shows the caption of "Query Properties". It might say "Field Properties" in which case you need to click anywhere above the field grid to change it.

Change the "Unique Values" property to 'Yes'. The underlying SQL will then be changed.

Rob

 

[ZmrAbdulla]

Hi RobCPA,

This is somthing smart.
Deserve a star

Zameer