CROSS-TAB Query --- INCONSISTENT Results ?!?!

  • Thread starter Thread starter kev100 via AccessMonster.com
  • Start date Start date
K

kev100 via AccessMonster.com

I've got several Cross-Tab queries that show totals for various fields in
various ways.

The feature has been really useful.

However, I notice occassional inconsistent totals.


For example....I can run a report using the totals......run it again a minute
later.....and notice that, sometimes, a total for a given field differs by 1
from the previous run.

(the core data does not change...these are generated from static databases).

I've not noticed it being off by more that 1 either way....but an occasional
1 here and there is enough to cause a problem.

Has anyone on else experience this?

Thanks
 
I've never seen it and would be interested in seeing some examples. If you
can induce the descepancy, please post the differing results and the SQL.

Just some random thoughts: Do any of the queries have a criteria on a
date/time field? Could it be a rounding problem?
 
Jerry said:
I've never seen it and would be interested in seeing some examples. If you
can induce the descepancy, please post the differing results and the SQL.

Just some random thoughts: Do any of the queries have a criteria on a
date/time field? Could it be a rounding problem?
I've got several Cross-Tab queries that show totals for various fields in
various ways.
Click to expand...
[quoted text clipped - 15 lines]
Thanks
Click to expand...
Click to expand...

Time/Date are not referenced in the queries....although the fields do exist
in the table.
The values in the referenced fields are Text..the math used totals (counts)
how may times a certain string appears.

For a quick description.....

The possible values for one of the fields in every record is either YS or NO.
Another field has the State (TX, GA, CA, etc) of the person to whom the
record refers.

The Query will simply output a Data Sheet with 50 lines (one for each state)
with 2 columns...YS and NO. Each line has the totals of YS' and NO's for each
state. The table could have 1000's of records....but each will only have
either a YS or NO in that field and will only reference 1 state.

I will try to get a pre/post descrepency....and post the SQL soon.

Thanks
 
Back
Top