Combo Box Issues

D

DK

I have a unlinked combo box which has a source file based on a row in a table
but I cannot group the data as it insists on showing all of the records in
the table even if only select the one field as if the *(select all) field is
there whether I like it or not.

Is there a way around this so I can group the data.
 
D

DK

SELECT MonthlyServiceReview.Month, * FROM MonthlyServiceReview WITH
OWNERACCESS OPTION;

Here the SQL the combo box generates.
 
O

Ofer Cohen

The problem is with the * which mean select all

Try
SELECT Distinct MonthlyServiceReview.Month FROM MonthlyServiceReview WITH
OWNERACCESS OPTION
 
D

DK

Worked a treat thanks. I need to learn SQL

Ofer Cohen said:
The problem is with the * which mean select all

Try
SELECT Distinct MonthlyServiceReview.Month FROM MonthlyServiceReview WITH
OWNERACCESS OPTION
Click to expand...
 
Top