Memory variable as query criteria

[Epic]

Hi,
Could anybody tell me if there is a way to use a memory variable as query criteria? If yes then How?

But not passing from VBA.

Thanks.

 

[neileg]

If you don't want to use VBA, you could store a value in a temporary table and create a join with the table or query that holds your data.

 

[Epic]

Thanks neileg

 

[The_Doc_Man]

But the problem is that to define that entry in the table, you STILL need VBA.

You are asking a question about two things that have different values of the attribute called "binding time" - a programming attribute, not an MS Access attribute in the sense of "properties."

The two items have different storage properties. Without VBA, you cannot bridge the property difference. So my answer differs from neileg's answer.

Could anybody tell me if there is a way to use a memory variable as query criteria? But not passing from VBA.

No.

 

[lino]

Hello,

could anyone tell me how to use the value of a variable as the criteria of a query. Im no expert in VBA but im learning,

thanks

Lino