Using the query builder I designed a query to find incomplete login details, e.g. someone who had forgotten to log out yesterday. The sql for this query is printed below:
SELECT [Forename] & " " & [Surname] AS Name, TabLogin.UserID, TabLogin.[Time In], TabLogin.[Time Out], TabLogin.Duration, TabLogin.LoginDate
FROM TabLogin INNER JOIN TabUserDetails ON TabLogin.UserID = TabUserDetails.ID
WHERE (((TabLogin.[Time In]) Is Null) AND ((TabLogin.LoginDate)<>Date())) OR (((TabLogin.[Time Out]) Is Null) AND ((TabLogin.LoginDate)<>Date())) OR (((TabLogin.Duration) Is Null Or (TabLogin.Duration)=0) AND ((TabLogin.LoginDate)<>Date()));
This query works on my machine, also on my boss's machine, but when I tried to run it on another machine I get an error message saying that the criteria is incorrect. It won't even let me look at it in design view, I get a message saying that the function etc. is not available. I've checked for viruses on the other machine, I've checked the date/calander format on the other machine and everything seems OK. To make matters worse, I designed a small database with only the required tables and queries needed to run a test, including the rogue query, and it works without a hiccup.
Can someone help?
regards
Geoff.
