Why this query does not work in my program but in Access works?

[tatinccr]

PARAMETERS [Param_Name] Text(255);
SELECT TOP 1 * FROM (SELECT PHAII01.CUSTID AS ID, PHACU.LNAME & ', ' & PHACU.FNAME AS NAME, PHAII01.Date
FROM PHAII01 LEFT JOIN PHACU ON PHAII01.CUSTID = PHACU.CUSTID
WHERE (((RTrim([PHACU].[LNAME]) & ' ' & RTrim([PHACU].[FNAME])) LIKE '%' & [Param_Name] & '%'))
ORDER BY PHAII01.Date DESC);

[jimatqsi]

What is your program? What do you mean by "my program" versus "in Access?" Do you mean you are trying to use this query string in VBA code and it doesn't work? If so, give us a look at your code.

In what way does it not work? What happens?

Jim