Re: how to compare a calculated value to a set of intervals?
Be careful of expressions that use fields from two (or more) unconnected tables. If the dataset is small, they will perform OK, but if it is larger, you will run into "out of memory" errors when QV tries to create a cross join to perform the calculations.
You are better off using intervalmatch when reloading. From your second post, that would seem to be the correct way. Search the forum for intervalmatch, there are many postings on the topic, and check out intervalmatch in the manual.
Hope that helps
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein