Re: different results of query from different workstations
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Feb 2008 18:39:26 -0700
On Tue, 19 Feb 2008 17:09:01 -0800, Durian62
<Durian62@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
My multi-user database is on a server and I experience different query
results depending on from which workstation the query is run.
The query converts a txt-field into a date format with the following
command: format([left([variable xyz],16,?General Date?) with a criteria of
?>Now()-26/24?.
If I remember correctly the problem is linked to differences in the setup of
Access on each single machine (possibly add-ins?) ? who can help?
General Date will have variable appearance depending on the computer's
Regional date/time settings. What are the typical contents of [variable xyz]?
I suspect that a DateSerial and/or TimeSerial function will be a better choice
than Format().
Note that Format will return a text string, not a Date/Time value, and that
the Now() expression might better be
= DateAdd("h", -26, Now())
if your intention is to find all values more recent than 26 hours ago. If
that's not your intention... what is?
--
John W. Vinson [MVP]
.
- Prev by Date: Re: memo field truncated in excel
- Next by Date: Re: different results of query from different workstations
- Previous by thread: Re: different results of query from different workstations
- Next by thread: Re: different results of query from different workstations
- Index(es):
Relevant Pages
|
