Excel - Querytable - SQL

[elleg]

Where do you have your SQL? Is it saved in a variable within a VBA module, or is it just a query in MS Query, or... ?

Also, as for the syntax of your SQL, I think you have some extra parenthesis and some misplaced parenthesis.

I think your SQL should probably be:

SELECT	* 
FROM	PRDADMIN_EVENT
WHERE	(PRDADMIN_EVENT.EVENTTYPEID	="RNDZ") 							AND 
	(PRDADMIN_EVENT.DESCRIPTION	="Reply Received - Outstanding = 0")				AND
	(
		PRDADMIN_EVENT.DATEEVENT	BETWEEN (DateAdd('d', -1, Date) + #7:00:00#)	AND
							(DateAdd('d', -1, Date) + #20:00:00#) 
	);

Or, in one line:

SELECT * FROM PRDADMIN_EVENT WHERE (PRDADMIN_EVENT.EVENTTYPEID	="RNDZ") AND (PRDADMIN_EVENT.DESCRIPTION="Reply Received - Outstanding = 0") AND (PRDADMIN_EVENT.DATEEVENT BETWEEN (DateAdd('d', -1, Date) + #7:00:00#) AND (DateAdd('d', -1, Date) + #20:00:00#));