Inconsistent Query Results

[Guest]

A form-driven query currently generates a report in USD, I've been asked to
create a similar report using local currency. (access 03; created by former
empl)

Seemingly simple, for an unknown reason, if I change the fields in the
query from the USD to the the local currency fields, ie changing
EstimatedLabour: [Projects]![YTD labour]+[Projects]![Furtherlabour] to
EstimatedLabour: [Projects]![YTD labour
local]+[Projects]![Furtherlabourlocal], the number of lines generated in the
report jumps from 4 to 81. All of the field settings are similar. I've been
able to isolate the jump in results to the change in the currency field. I'm
completely stumped as to how this can occur.

I realize it's a shot in the dark, but if anyone can recommended paths to
research, I would be most appreciative.

Cheers.

 

[Chris M]

Hi,

Could you show us some sample data, or maybe the design of the Table or the
full query?

There is not really enough to go on in what you have said. Sounds like a
really bizzare problem, though the answer will probably be boringly
simple...

Cheers,

Chris.