Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / November 2005

Tip: Looking for answers? Try searching our database.

Inconsistent Query Results

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
thechilipino - 23 Nov 2005 11:16 GMT
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 - 23 Nov 2005 13:20 GMT
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.

>A form-driven query currently generates a report in USD,  I've been asked
>to
[quoted text clipped - 18 lines]
>
> Cheers.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.