Is this query possible SELECT * FROM mytable WHERE ([myExpression]);

i'v got a question about sql in access 2007.

it's possible to generate a query like this:

SELECT * FROM mytable WHERE ([myExpression]);

in [myexpression] should be somet开发者_运维知识库hing like date between date1 AND date2 or even id > 123.

if it's possible: how? and if not.. shit happens ;)

This is only possible with VBA, where you can either create a recordset, or build or update a querydef.