Query outputs wrong results!

  • Thread starter Thread starter Ruben Granados
  • Start date Start date
R

Ruben Granados

Hi, in a form i'm showing the sum of hours per day/week
and month.
On my computer is working fine (is the pc where i
developed the application) today we installed the mde's on
users computers, and problems started... the queries are
not displaying the right results..

what's happening?
 
Ruben,

Just guessing here, but I suspect it has to do with date/time formats. To
verify, select a PC on which you are getting wrong results, and set the date
and time format in the Windows Regional Options to the same one you have on
your PC. If this fixes the error, then that's the source of your problem. In
that case, youhave two options:
(a) apply the same changes to all PC's, or
(b) use functions such as Format, Year/Month/Day throughout your application
where date/time fields are handled.

Option (b) is more robust in that it is insensitive to users changing their
regional settings to their liking, plus it is PC-independent, so once you
get it right you can deploy to any number of PC's without worrying about it
anymore.

HTH,
Nikos
 
Ruben Granados said:
Hi, in a form i'm showing the sum of hours per day/week
and month.
On my computer is working fine (is the pc where i
developed the application) today we installed the mde's on
users computers, and problems started... the queries are
not displaying the right results..
Click to expand...

I have two questions to start:

1) What should these queries display?

2) What are these queries displaying?
 
I have two questions to start:

1) What should these queries display?

2) What are these queries displaying?
Click to expand...

and perhaps also

3) What's the SQL of the query?
 
Back
Top