PARAMETERS [Search Details:] Text ( 255 );

[Top Dog]

PARAMETERS [Search Details:] Text ( 255 );
SELECT [gsh test1].[Job Number], [gsh test1].[Cell I D], [gsh test1].[In
number], [gsh test1].[Site Name], [gsh test1].[SLA Date], [gsh test1].Fault,
[gsh test1].[time on site ] AS Expr1, [gsh test1].[Time off site], [gsh
test1].[Total Time], [gsh test1].[Completed Date], [gsh test1].Completed,
[gsh test1].[Details of Works Carried Out], [gsh test1].[Reason for
Incomplete Works], [gsh test1].Status, [gsh test1].[closed on maximo], [gsh
test1].[closed on Atlas]
FROM [gsh test1]
WHERE ((([gsh test1].[Site Name]) Like"*[Search Details:]*"));
why doesnt this work currectly

 

[Dirk Goldgar]

PARAMETERS [Search Details:] Text ( 255 );
SELECT [gsh test1].[Job Number], [gsh test1].[Cell I D], [gsh
test1].[In number], [gsh test1].[Site Name], [gsh test1].[SLA Date],
[gsh test1].Fault, [gsh test1].[time on site ] AS Expr1, [gsh
test1].[Time off site], [gsh test1].[Total Time], [gsh
test1].[Completed Date], [gsh test1].Completed, [gsh test1].[Details
of Works Carried Out], [gsh test1].[Reason for Incomplete Works],
[gsh test1].Status, [gsh test1].[closed on maximo], [gsh
test1].[closed on Atlas]
FROM [gsh test1]
WHERE ((([gsh test1].[Site Name]) Like"*[Search Details:]*"));
why doesnt this work currectly

Probably because your parameter placeholder is embedded in a string
literal. Try this:

WHERE ((([gsh test1].[Site Name]) Like"*" & [Search Details:] &
"*"));