Recent content by Kapten

Hi GalaxiomAtHome, thanx for your reply. I inserted AS in the query but that didn't make any difference. This query works in MS-SQL-Server. I'm trying to get the latest sendTime from TblContactSent (if there are any) . This table can have many rows for each contactId but I only want the latest...

Hi, I changed from MS SQL-Server to MS Access in an application and a SQL-select statement stoped to work. Here is the code: "SELECT TblContact.*,(select top 1 cs.sendTime FROM TblContactSent cs WHERE TblContact.contactId = cs.contactId ORDER BY cs.sendTime DESC) as ST from tblContact ORDER BY...