How to convert a Access query to SQL..

[Gjakovari]

SELECT ALL_Staff.ID, [Lastname] & ", " & [FirstName] AS FullName
FROM ALL_Staff
WHERE (((ALL_Staff.La stName) Like [forms]![ALLStaff_by_Alp habet]![txtLastNameFilt er] & "*"))
ORDER BY [Lastname] & ", " & [FirstName];


Thanks a lot

[TheSmileyCoder]

Hi and welcome to BYTES

Im not really sure I understand what it is you want us to do?

[Gjakovari]

haha, ok, you're right..I have a access database mdb, and now I am trying to migrate it to SQL, and run it throught access adp file.. Now most of the work is done.. I am stuck in one of the queries where the criteria set on the access old database dont fit with the new system (SQL- adp file) Criteria sent earlier, are those that I use in mdb file..So if you could help convert the same ones to apply for the adp file.. I hope i was clear enough ..

[TheSmileyCoder]

I understand now. Afraid I can't help though, as I have no knowledge of Access and SQL server interaction. Im sure someone here can assist though.