Query's returning values that are double

  • Thread starter Thread starter HWylie
  • Start date Start date
H

HWylie

I'm getting a rather strange set of results running simple
queries against a single table. When "they" are initially
written they return the correct results, but seamingly at
random times they start consistantly returning exactly
twice the numeric value for the results. The only math
is a simple sum of six different fields. One field is
sorted in decending order value. To temporarily correct
the problem I write a new query with exactly the same
variables and structure and the correct result is
obtained. This eventually starts reporting double the
results too. The table has not been modified and has been
audited to validate what results should be produced. My
conclusion is that this is a bug in Access that causes a
query to run twice while not reiniating fields used for
totals. When I run the old and new queries in sequence
against the exact same data I get the expected results in
one and twice the numeric results in the other, i.e. 2 vs
4. Anyone have any ideas on what I might be doing to
cause this?
Thanks,
Hunter
 
Back
Top