Filter Records in a report

[mcambrose]

I have a report which is based on a query named Members which has a field
named Exp1:. I want the report to only show records in which Expr1: starts
with the letters A-F. I tried to add the expression below to the filter field
of the report properties. I get a syntax error when I try to print preview
the report. I can't find any information or examples for the way to write
these expressions. Maybe I have to use a named filter created somewhere else.
Any help would be appreciated. I can do the filter in the query if I can't
figure this out.


Exp1: like "[A-F]*"

Thanks

 

[JoyAA]

In the Filter On Property for the report enter:
[EXPR1] like "[A-F]*"

This should correct your syntax error. In general, you want your
filter to read the same way it would if it were in the WHERE clause
of your query.