The problem happens if you have any spaces in your filter, along with Query functions. For example, spaces before or after the equals sign =, or parenthesis ( ). Eliminating these spaces (which doesn't affect formula syntax) seems to be OK, where filters with extra spaces for readability has the problem occur.

I have no spaces.

Hi bal,

=QUERY() functions also have a problem it appears. Are you using this in the filter? Has someone sent you the link to the service pack? I know it's been done.

If not, I apologize.

Andrew

Andrew is mistaken, no service pack has yet been release to the public (or dealers for that matter).

Hi Doug,

The announcement will go out today. The work has been done. Usually we try and get the fix directly to companies that have encountered the problem.

It is a Query function.

I've got to get some reports out...is there going to be a fix. If not, I'm going to have to use another way to accumulate the information.

I know the other way and it takes a long time!

Thanks.

Hi Cheryl,

There will be a fix posted today. I've asked someone to make sure that you are sent the link as soon as the files are up and ready to download. I'm on the road (as you know).

Sorry for the inconvenience.

Thanks a lot.

Hi Cheryl,

Michael from our office has left a voicemail message for you. He wants to make sure that we've fixed the problem you are having.

The Service Pack is being installed and tested live now. The channel announcement will go out shortly. By Thursday, we hope to send the special announcements to those who contacted us about the specific problem and then we'll send the announcement to all registered users.