Only one entry for a query

[ennrike]

Hi,

I have a query for selection, for example:

SELECT WorkOrderNumber FROM MyTable WHERE HourPlan > 10

Because I have duplicates of "WorkOrdersNumbers" in MyTable, the query gives me more than one row of a simgle "WorkOrdersNumbers", what should I add to the query to make sure it is only one "WorkOrdersNumbers" per row.

I am aware that I will not get all info of each "WorkOrdersNumbers" but it does not matter for me, I dont want to have duplicates in the result of the query.

Thanks,

 

[John Big Booty]

Havea look at a Totals Query.

 

[ennrike]

By the way, I need to use also "TOP", I mean:

SELECT TOP 50 WorkOrderNumber FROM MyTable WHERE HourPlan > 10 ORDER BY Date