B
blake7
Hi I have the following expression in a query six times searching for
different words in the “LIKE†area.
Expr1: DCount("*","[main Audit Data]","[Boiler Type] LIKE '*icos*'")
Everything works fine but I would like to enter some criteria between two
dates from my main table, I have tried making a form from the query which
displays the six boxes OK, then tried adding two text boxes or two combo
boxes to act as the criteria etc, but it does not seem to work
I have tried the following;
Between [forms]![my form name]![text1] and [forms]![my form name]![text2]
Is it possible to set criteria for an expression??
Regards Tony
different words in the “LIKE†area.
Expr1: DCount("*","[main Audit Data]","[Boiler Type] LIKE '*icos*'")
Everything works fine but I would like to enter some criteria between two
dates from my main table, I have tried making a form from the query which
displays the six boxes OK, then tried adding two text boxes or two combo
boxes to act as the criteria etc, but it does not seem to work
I have tried the following;
Between [forms]![my form name]![text1] and [forms]![my form name]![text2]
Is it possible to set criteria for an expression??
Regards Tony