How do I 'prompt' in Access???

[JMOSLEY]

SELECT COLUMN_1, COLUMN_2
FROM TABLE_NAME
WHERE COLUMN_2 = '&COLUMN_2';

I'm trying to manually enter 'COLUMN_2' to retreive the data

 

[Mary]

Post this in the Access NG.