Hair Pulling Error

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I really hope someone else has run into this before.

I have built a database that resides on a shared network
drive. In the db there is a form with a calendar control
and buttons to run the various reports.

When I open the DB and run a report for 12/1/2003 -
12/31/2003 on my computer it gives one set of values, but
when I run it from ANY other computer from the exact same
file, form, and dates I get a different set of values
returned.

Absolutely nothing is different about the way it is being
run except the physical location of the computer on the
same network.

I would sincerely appreciate ANY help or suggestions that
anyone has to offer.

Tom
 
Could be an "abiguous date" problem
When you present the date to the where clause of the query
or report use the format "dd mmm yyyy" or "mmm dd yyyy"
as in
Between
"#" & Format$(fromdate, "mmm dd yyyy") & "#"
and
"#" & Format$(todate, "mmm dd yyyy") & "#"

Using mmm (translates to Jan, Feb etc), access can't get
confused.
 
Back
Top