Doug Murphy
dw-murphy at cox.net
Thu Nov 12 12:11:11 CST 2009
Folks, Hopefully someone here can provide some insite in why a client gets an error on a query I created and I don't. The client wanted a way to search a large table of event times and find those events that occure within a plus or minus time of times in another table. I don't have the source tables so created an example database and a set of sample tables. The query is as follows. SELECT tblEventTime.ID, tblEventTime.EventTime, qryTimeSpan.compTimeID, qryTimeSpan.CompTime, qryTimeSpan.low, qryTimeSpan.high FROM tblEventTime INNER JOIN qryTimeSpan ON tblEventTime.EventTime BETWEEN qryTimeSpan.low AND qryTimeSpan.high; This runs fine for me in Access 2003 and 2007 on my systems. The client runs the sample on her computer with Access 2007 and gets an error message saying "Between operator without And in query expression 'tblEventTime.EventTime BETWEEN qryTimeSpan.low" I have tried playing with trust levels in my copy of Access 2007 and this doesn't make any difference. Any suggestions on what might be going on? Thanks in advance. Doug