User Defined Variable via Query(Via pop up box) in Access

[Lynux]

I am wanting to have a user defined variable name in an access query (so that a pop up box prompts user for input)

here is what I have:
SELECT *
FROM ORD00000
GROUP BY ORD00000.ITEM_NO, ORD00000.CAT_TYPE, ORD00000.PRE_EST, ORD00000.FIN_ORD, ORD00000.LST_YR_TOT;

here is what I Need:
SELECT *
FROM &user_defined&
GROUP BY &user_defined&

Thanks in advance!
=================================
Imagination is more important than knowledge.
(A.E.)

 

[Databaseguy]

Paste you SQL statement in a new query. Switch to design view. In the criteria field for the field you want an input for, type soemthing like:

[Please enter a value]

When you run the query, an input box will pop up.