Grouping & Parameters

[arage]

Grouping & Parameters
Hope someone can correct me on what I’m doing wrong, I’ve tried 2 versions of the below query which always end in ODBC failures. Any help is appreciated.

SELECT DistributorInput.DistributorNumber, DistributorInput.InputFileName, Count(DistributorInput.InputFileName) AS CountOfInputFileName
FROM DistributorInput
GROUP BY DistributorInput.DistributorNumber, DistributorInput.InputFileName
HAVING (((DistributorInput.DistributorNumber)="10002") AND ((DistributorInput.InputFileName) Like "*" & [FILE NAME like?] & "*"));

AND

SELECT DistributorInput.DistributorNumber, DistributorInput.InputFileName, Count(DistributorInput.InputFileName) AS CountOfInputFileName
FROM DistributorInput
WHERE (((DistributorInput.InputFileName) Like "*" & [FILE NAME like?] & "*") AND ((DistributorInput.DistributorNumber)="10002"))
GROUP BY DistributorInput.DistributorNumber, DistributorInput.InputFileName;

SELECT DistributorInput.DistributorNumber, DistributorInput.InputFileName, Count(DistributorInput.InputFileName) AS CountOfInputFileName

 

[pdx_man]

The first one looks like it should be fine. What is the ODBC error? ODBC Timeout ... Couldn't Find ...