Duplicate records in a Query

[Angel_G]

Hi there!
Can any one help with this.
I have an Orders table that contains OrderNumber and OrderLineNumber along
with Messages per line number.
When I want to retrieve the OrderLineNumber, duplicate records exist because
there are multiple messages per OrderLineNumber.
I think that if I concatenate the Order number with a line number and put
some criteria under this new field ("COLN:[OrderNumber]&[OrderLineNumber]")
I should be able to get unique records.
The problem is that I do not know what Criteria to use.
Can anyone help me?
Thanks in advance.

 

[Jason Byrnes]

Try This:

SELECT DISTINCT OrderLineNumber FROM YourTable

Jason