USING (LIKE) IN A QUERY

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Please help. The problem is with the like COPE*

This will work in a stored query but not in VBA SQL CODE ???

SELECT PRC_ADJ.END_DATE, Min(PRC_ADJ.ADJ_AMT) AS MinOfADJ_AMT
FROM PRC_ADJ
WHERE (((PRC_ADJ.NAME) Like 'COPE*'))
GROUP BY PRC_ADJ.END_DATE, PRC_ADJ.MANUF
HAVING (((PRC_ADJ.END_DATE)=IIf(Date()<[END_DATE],[END_DATE])) AND
((PRC_ADJ.MANUF)='US TOBACCO'));
 
Try the Unix wildcards _ and % instead of DOS wildcards ? and *


Vanderghast, Access MVP
 
Thank-You
Amazing what you can learn

Michel Walsh said:
Try the Unix wildcards _ and % instead of DOS wildcards ? and *


Vanderghast, Access MVP


Mike said:
Please help. The problem is with the like COPE*

This will work in a stored query but not in VBA SQL CODE ???

SELECT PRC_ADJ.END_DATE, Min(PRC_ADJ.ADJ_AMT) AS MinOfADJ_AMT
FROM PRC_ADJ
WHERE (((PRC_ADJ.NAME) Like 'COPE*'))
GROUP BY PRC_ADJ.END_DATE, PRC_ADJ.MANUF
HAVING (((PRC_ADJ.END_DATE)=IIf(Date()<[END_DATE],[END_DATE])) AND
((PRC_ADJ.MANUF)='US TOBACCO'));
Click to expand...
Click to expand...
 
Back
Top