Query outputs wrong results!

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?
 
N

Nikos Yannacopoulos

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
 
C

Chris2

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?
 
J

John Vinson

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?
 
Top