Order by Problem

[Jmsteph]

Hello,

The following code will pull all of the funds that match to the product. The problem is I can not get them to sort by the FundName. Can someone show me where to add the order by into the following code so it sorts correctly as I just cant figure it out? Thanks!!!!

SELECT [TradeFundInfo].[FundName] FROM [TradeFundInfo] WHERE ((([TradeFundInfo].[Product])=[Forms]![CallLogNewTrade]!ProductCombo])));

 

[pbaldy]

You could just add it in design view of the query, but this should work:

SELECT [TradeFundInfo].[FundName] FROM [TradeFundInfo] WHERE ((([TradeFundInfo].[Product])=[Forms]![CallLogNewTrade]!ProductCombo]))) ORDER BY FundName

 

[Jmsteph]

That worked perfectly. Thanks!!!!

 

[pbaldy]

Happy to help!