T
Tim
I just upgraded to Office 2007 yesterday. I regularly work in a SQL 2005
database that I link to via ODBC in Access. When I used Access 2003, I could
right click inside a column and enter criteria in the 'Filter For' box, such
as the following:
ISS-* or *pcweb*
And it would return all records that started with ISS- and that included
pcweb. Now if I right-click and enter the same thing in one of the new Text
Filters options, I get no results. I've specifically tried "Equals" and
"Contains" and entered the exact same type of line you see above, which
worked fine in 2003, and now it returns 0 results. I've looked at 'Filter by
Form' afterwards to see what Access is doing, and it includes my entire
string in quotes, as if I'm looking for "ISS-* or *pcweb*" literally
(including the 'or' and astericks).
Any suggestions? Is there an easy way to replicate what I did in Access 2003?
database that I link to via ODBC in Access. When I used Access 2003, I could
right click inside a column and enter criteria in the 'Filter For' box, such
as the following:
ISS-* or *pcweb*
And it would return all records that started with ISS- and that included
pcweb. Now if I right-click and enter the same thing in one of the new Text
Filters options, I get no results. I've specifically tried "Equals" and
"Contains" and entered the exact same type of line you see above, which
worked fine in 2003, and now it returns 0 results. I've looked at 'Filter by
Form' afterwards to see what Access is doing, and it includes my entire
string in quotes, as if I'm looking for "ISS-* or *pcweb*" literally
(including the 'or' and astericks).
Any suggestions? Is there an easy way to replicate what I did in Access 2003?