Parameters as Select items

[Bully]

Is it possible to use parameters in the select line e.g.

PARAMETERS Param1 Text ( 255 );
SELECT [Param1] AS Expr1
FROM Customers
WHERE [Name] = 'John Smith';


For Param1 I would pass in 'D.O.B.' and it should return me
Expr1=2003/5/9

This does not seem to happen, I just get Expr1=Param1

Any ideas?

Thanks
Jon

 

[Allen Browne]

That should work.

Make sure the declaration is identical, with the square brackets:
PARAMETERS [Param1] Text ( 255 );

If you are still stuck, let us know what version of Access you are using.

(Naturally the Text type won't behave like a date.)