I have a table that has these three fields, FILENO, CODE, TRANS_DATE. There is no primary field set but FILENO is the main field. I'm using the following query to find the last code that begins with "S" (along with other conditions) with the latest date.
SELECT A.FILENO, LAST(A.CODE) AS SCODE, MAX(A.TRANS_DATE) AS L_DATE
FROM dbo_ACTIVE AS A
WHERE A.CODE Like "S*" And A.CODE Not Like "SCAN*" And A.CODE NOT LIKE "SACORT"
GROUP BY A.FILENO;
That works fine. I am however trying to use Excel to link to this query but it will not show any of the records. Any reason why?