I'm trying to use a simple filter in a report. I have a table column called 'Server Name'. When I try to filter for all servers whose name starts with 'F' by using:
Left([Server Name],1) = "F"
And try to view the report, Clippy responds:
One or more operators in the filter expression is invalid.
For a valid list of operators refer to the help file.
I'm sure I'm using Left() correctly - I mean, how can you screw that up? Any ideas what it is Clippy doesn't like?
TIA...
Left([Server Name],1) = "F"
And try to view the report, Clippy responds:
One or more operators in the filter expression is invalid.
For a valid list of operators refer to the help file.
I'm sure I'm using Left() correctly - I mean, how can you screw that up? Any ideas what it is Clippy doesn't like?
TIA...