Inconsistant crosstab Resuts

  • Thread starter Thread starter Wayne Huxman
  • Start date Start date
W

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
 
Wayne Huxman said:
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
Click to expand...

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
 
Back
Top