Access 97 Query joined on dates

[Jeff Scroggins]

we have a query that joins a table to another query using the date. It
works on some computers but not others. It's the damnest thing I've
ever seen.
We run Windows XP and Access 97 sp 2.
Some machines have xp SP2, some still have SP1
Some machihnes have Acess 97 and Access 2000
I'm not able to find any common cause to this problem

 

[Douglas J Steele]

Do you get an error? If so, what is it? If not, can you describe what's
happening on the machines where it doesn't work?

Are you using the Date function? On the machines where it doesn't work, does
the Date function work? (Open the Immediate window, using Ctrl-G, type
?Date() and hit Enter) If that's the case, odds are you have a problem with
your Reference collection.

On the machine(s) where it's not working, open any code module, then select
Tools | References from the menu bar. Examine all of the selected
references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

 

[Jeff Scroggins]

Doug,
Thanks for your response.
I am joining 2 tables and a query: Prod_Data tbl has primary key. Downtime
tbl has foreign key
Join is:
Prod_Data.ID --> Left Join Downtime.ProdID
Prod_Data.Date --- Inner Join on AreaHours.Date
I use a form value for Prod_Data.Date Parameter
Query returns records on some machines; on other it returns no records.
All the machines use the same references.
I was wondering if you had ever run into this type of problem?




Jeff

 

[Douglas J. Steele]

Sorry, no, I've never encountered anything like this.

What's the actual SQL of your query? What format is the form value of the
date?

BTW, Date is not a good choice for a field name. It's a reserved word, and
you can get into problems using it for your own purposes. You might consider
renaming that field, and seeing whether the problem persists.