Tuesday, June 20, 2006

Why Can't I Filter Aggregate Fields in the List or Between

So here's a scenario: you're running Foxfire! and decide to build a summary report that shows Count of Records. You're interested in seeing records where you have between 10 and 20 items.

You use the BETWEEN filter, right?

Unfortunately, no. This will give you an error in FoxFire!. Instead use the Greater than and then Less than values.

This is a carry over from Foxfire! 1.02 that we'll be fixing soon.

But I wanted to make sure it was noted.

Technically the reason is because In the List and Betweens work best with character values or dates.

0 Comments:

Post a Comment

<< Home