Inconsistant crosstab Resuts

[Wayne Huxman]

I'm trying to determine why a crosstab query is returning different results
on some calculated fields than it did some months ago when it was first run.
The data and query are the same to the best of my knowledge. Anyone ever
encounter a similar situation - any comments are welcome. Thanks.

Wayne

 

[jim]

I'm trying to determine why a crosstab query is returning different results
on some calculated fields than it did some months ago when it was first run.
The data and query are the same to the best of my knowledge. Anyone ever
encounter a similar situation - any comments are welcome. Thanks.

Wayne

I too have been having query problems producing inconsistant results-
same data no changes, different results.

I have a function in the query that looks up a global variable-
sometimes it is comes back correct sometime it comes back null (???).

In an attempt to get around the caching problem, I pass the function
the record's primary key (long) - which isn't needed). The function
receives it as a variant. After i passed Now() to the function and
changed the function to a receive a date it seems to be working (still
testing).
jim