[AccessD] Query error

Doug Murphy dw-murphy at cox.net
Thu Nov 12 13:34:30 CST 2009


Hi David,

I get a "Join not supported" message with this query. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Thursday, November 12, 2009 10:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query error

Does this work?

SELECT
	tblEventTime.ID,
	tblEventTime.EventTime,
	qryTimeSpan.compTimeID,
	qryTimeSpan.CompTime,
	qryTimeSpan.low,
	qryTimeSpan.high
FROM tblEventTime
	INNER JOIN qryTimeSpan
		ON tblEventTime.EventTime
WHERE tblEventTime.EventTime BETWEEN qryTimeSpan.low AND qryTimeSpan.high;



On Thu, Nov 12, 2009 at 10:11 AM, Doug Murphy <dw-murphy at cox.net> wrote:
>
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list