Link to home
Start Free TrialLog in
Avatar of geeta_m9
geeta_m9

asked on

Is there a way to place the value of a variable as a criterion in the Query Design Window

I am trying to use the value of a variable as a criterion in the Query Design Window.

For example, I have the variable, ID_Flag, and I would like the ID column in the query to be equal to the value of ID_Flag as the critieria. However, Access won't allow me to do that. It keeps putting quotes around the variable name so it looks like this "ID_Flag". How do I get around this?

Thanks.
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of geeta_m9
geeta_m9

ASKER

Both the solutions work. Thanks.