SQL Question

[PeterL]

I have the following SQL statement in Access and want to change it so only unique occurances of the EXPR1 field get returned. How could I modify the following SQL statement:

SELECT Revised_Invoices_temp.*, [OrganizationName]+Str$([InvoiceNumber]) AS Expr1
FROM Revised_Invoices_temp
ORDER BY Revised_Invoices_temp.OrganizationName, Revised_Invoices_temp.InvNum;

Thanks

 

[mike250]

Using DISTINCT.

 

[PeterL]

Thanks, but where am I placing DISTINCT? Would this go directly after the SELECT?

 

[GTLoco99]

yes