Hi All
I am new to SQL queries I have the following problem. I need to have the Software Name in ascending order in the query. How and what do I need to do with the query.


SELECT Softwareinfo.SoftwareID, Softwareinfo.SoftwareName, Softwareinfo.Softwareconflicts, Softwareinfo.TivoliDistributionPackage, Softwareinfo.softwarelocation, Softwareinfo.SoftwareDependencies, Softwareinfo.contactdetails, Softwareinfo.versiondetails, Softwareinfo.Contact, Softwareinfo.generalcomments, Softwareinfo.licence
FROM Softwareinfo
WHERE ((Softwareinfo.SoftwareName) Like [forms]![Mem]![SoftwareName] & "*")and((Softwareinfo.contact) Like [forms]![Mem]![contact] & "*")and((Softwareinfo.softwarelocation) Like [forms]![Mem]![softwarelocation] & "*")and((Softwareinfo.SoftwareDependencies) Like [forms]![Mem]![SoftwareDependencies] & "*")and((Softwareinfo.TivoliDistributionPackag e) Like [forms]![Mem]![TivoliDistributionPackage] & "*")and((Softwareinfo.VersionDetails) Like [forms]![Mem]![VersionDetails] & "*")and((Softwareinfo.Softwareconflicts) Like [forms]![Mem]![Softwareconflicts] & "*");


Thanks

Brendan Bartley

__________________
Brendan Bartley

Doesn't this work?

SELECT Softwareinfo.SoftwareID, Softwareinfo.SoftwareName, Softwareinfo.Softwareconflicts, Softwareinfo.TivoliDistributionPackage, Softwareinfo.softwarelocation, Softwareinfo.SoftwareDependencies, Softwareinfo.contactdetails, Softwareinfo.versiondetails, Softwareinfo.Contact, Softwareinfo.generalcomments, Softwareinfo.licence
FROM Softwareinfo
WHERE ((Softwareinfo.SoftwareName) Like [forms]![Mem]![SoftwareName] & "*")and((Softwareinfo.contact) Like [forms]![Mem]![contact] & "*")and((Softwareinfo.softwarelocation) Like [forms]![Mem]![softwarelocation] & "*")and((Softwareinfo.SoftwareDependencies) Like [forms]![Mem]![SoftwareDependencies] & "*")and((Softwareinfo.TivoliDistributionPackag e) Like [forms]![Mem]![TivoliDistributionPackage] & "*")and((Softwareinfo.VersionDetails) Like [forms]![Mem]![VersionDetails] & "*")and((Softwareinfo.Softwareconflicts) Like [forms]![Mem]![Softwareconflicts] & "*")
ORDER BY Softwareinfo.SoftwareNamr ASC;




mmcdonal

Look it up at: http://wrox.books24x7.com